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.
Markdown is the most popular way to format plain text. Add common characters like asterisks and dashes to text, much like how you might format a quick store list in your notes app or add emphasis ...
Or do you use the Linux subsytem in Windows, emulation tools like DosBOX and WINE, or mobile device emulator/simulators? What's your favorite ways you've used virtual machines and emulation?
That would be very handy, thanks for sharing!