Question

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

Share
yoavbguttman's avatar
3 years 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
3 years 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 )
3 years ago

That would be very handy, thanks for sharing!

1 point
jbcapiche's avatar
3 years 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 )
3 years 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 )
3 years 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 )
3 years 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
3 years ago

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

3 points
mtanguma_'s avatar
3 years 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_ )
3 years 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 )
3 years ago
3 points
maguay's avatar
@maguay (replying to @mtanguma_ )
3 years ago

That's awesome!

1 point
bencapiche's avatar
3 years 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
3 years 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
3 years 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
3 years ago

Can't live without lucidchart

2 points
Giladi23's avatar
3 years 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
3 years 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
What are the best platforms for community management?

We have 15k newsletter subscribers, and have around ~2k of them in a Slack group. We're starting to encounter issues in terms of community management - specifically, it's hard to pin content like c...

Any suggestions for a workaround to an Outlook calendar not syncing with Google Calendars?

Google lets you subscribe to a calendar using a URL - although when using an Outlook 365 Calendar link, events are copied over once, and then the syncing stops. This seems to be a relatively new is...

The community for power users.