Question
What are the Google Docs or Sheets add-ons you couldn't live without?
Share
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.
Adding Googles Table Capture on the Chrome browser makes for an amazing tool to grab and digest data!
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.
Very cool! What eCommerce platform are you using, and does it directly integrate with Google Sheets?
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.
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.
Go/Links - can't live without them. Especially when sharing any G-Suite product with colleagues via their Slack integration.
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?
It works inside of the native Slack app: https://medium.com/@golinks/introducing-the-official-golinks-slack-app-d6337fb834d2
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.
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.
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
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.
That would be very handy, thanks for sharing!