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.
Yet Another Mail Merge add-on has been a good way to send bulk emails using Google sheet.
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
That's awesome!
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
Can't live without lucidchart
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...
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.
Looking for a better way to plan remote meetings across time zones, and keep up with events. What software is doing that best today?
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...
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...
That would be very handy, thanks for sharing!