Question

What are the Google Docs or Sheets add-ons you couldn't live without?

Share
yoavbguttman's avatar
a year ago

G-Connector for Salesforce makes the data from Salesforce actionable and easy to see for anyone in our organization. Additionally, I have used it to create dashboards, screens, automated reporting, and so much more that just would not be as accessible or analyze-able if it was stuck in Salesforce or I relied on manual exports.

4 points
adam_moulding's avatar
a year ago

Adding Googles Table Capture on the Chrome browser makes for an amazing tool to grab and digest data!

3 points
maguay's avatar
@maguay (replying to @adam_moulding )
a year ago

That would be very handy, thanks for sharing!

1 point
jbcapiche's avatar
a year ago

Using google sheets an its csv sharing feauture, I'm able to dynamically update the offering of my ecommerce website, without having to manage a complex CMS or a database.

Every day, someone update the catalog with next day's products, 5 minutes later the website is up to date.

3 points
maguay's avatar
@maguay (replying to @jbcapiche )
a year ago

Very cool! What eCommerce platform are you using, and does it directly integrate with Google Sheets?

1 point
jbcapiche's avatar
@jbcapiche (replying to @maguay )
a year ago

It's a custom website, coded by hand and tailored to our needs !
Technically, one can simply curl / wget / ... the csv file from google servers.

2 points
maguay's avatar
@maguay (replying to @jbcapiche )
a year ago

I would have thought you'd need to connect with the Google Sheets API—didn't realize it had a built-in .csv auto-export without clicking through menus. That's really neat.

3 points
kehers's avatar
a year ago

Yet Another Mail Merge add-on has been a good way to send bulk emails using Google sheet.

3 points
mtanguma_'s avatar
a year ago

Go/Links - can't live without them. Especially when sharing any G-Suite product with colleagues via their Slack integration.

https://www.golinks.io/

3 points
maguay's avatar
@maguay (replying to @mtanguma_ )
a year ago

That's an incredibly clever use of short links; hadn't come across that before. Thanks for sharing!

Does it work natively inside Slack, or do you have to run Slack inside Chrome to use Go/Links?

1 point
mtanguma_'s avatar
@mtanguma_ (replying to @maguay )
a year ago
3 points
maguay's avatar
@maguay (replying to @mtanguma_ )
a year ago

That's awesome!

1 point
bencapiche's avatar
a year ago

SuperMetrics for Google Sheets helps save me and my team a ton of time pulling data across several analytics and marketing platforms (Google Analytics, DoubleClick, MOZ, etc.). There can be some hiccups depending on the complexity of the queries but overall it's been super helpful.

3 points
Chris521S's avatar
a year ago

The Jira Cloud for sheets add-on is extremely useful and allows custom reporting (much more than what's available natively in Jira) from any number of projects.

2 points
sevketarslan's avatar
a year ago

Jira Cloud for Sheets is my favorite as it lets you to report however the way I want as I feel the reporting features or Jira can be improved. Alsoc not everyone in the organization is using Jira so Google Sheets let me share one single link with everyone and they can see an up to date dashboard on what’s going on.

PS: second favorite would be draw.io as beinf a product guy, it let’s me draw all soft of flows, wireframes, etc

2 points
_sachinsharma's avatar
a year ago

Can't live without lucidchart

2 points
Giladi23's avatar
a year ago

With no doubt, Google Table Capture which makes my life so much easier!
On so many occasions I've tried to copy tables to Excel and Google Sheets and it's messed up all the formatting...

1 point
mike_seekwell's avatar
a year ago

We (https://seekwell.io/) built a Sheets addon that lets you sync data from SQL (e.g. Postgres, MySQL, etc.) to Sheets. You can set the sync to happen daily, hourly or every five minutes.

1 point
The community for power users.