Subscribe
Sign in
Actiondesk for Google Sheets — Automatically push data to Google Sheets without code
Actiondesk allows you to push data from any application, including Airtable, SQL databases, Hubspot, Salesforce, Zendesk and more to Google Sheets. You can schedule routine pushes to Google Sheets (as often as every 5 minutes)
20
Replies
Looking great! Well done Actiondesk team!
There are many tutorials on how to use Actiondesk with other tools with no-code on Makerpad https://www.makerpad.co/company/...
nice. This can solve problems for many companies.
I have looked at a couple of similar tools that get the data from PostgreSQL. But haven't found one that can deal with the ssh tunnel. Does your tool provide that?
Hey @christoph_loewenherz ,
Yes our users can connect their PostgreSQL database using SSH!
Is there a big use case for this? It's currently fairly trivial to upload data to sheets automatically using a bit of code and the api.
Hey @duarteosrm ,
The main use case is for:
- non technical teams who couldn't code this out
- developers who'd rather not create a script and maintain it for every such automation.
@hnshah Thank you for hunting us! 🙏
Hello Product Hunt,
We are thrilled to be back here 🙃
We initially launched 6 months ago, with the mission of empowering anyone to build powerful automations using only their spreadsheet skills. 🤓
We've learned a ton since we launched and today we are launching Actiondesk for Google Sheets.
By talking to our users and +1,000 companies, we've learnt most non technical teams struggle to access data and build tools with it.
What they commonly do is download data from their backend, billing software, CRM, etc. to CSV and then copy paste it in Google Sheets or Excel. They then build tools on Google Sheets / Excel using that external data.
Every time they want to refresh their tools, they have to go through that manual process of extracting data again
This is now over thanks to Actiondesk for Google Sheets, without any code involved.
What can you do with it?
- Move sales data from your MySQL / PostgreSQL database to Google Sheets
- Get automatically your salesforce opportunities (or others) into Google Sheets to build custom reports
- Get automatically billing data from Stripe into Google Sheets to build custom reports
- Move data from Airtable to Google Sheets to perform calculations or backup your data
A few things that makes Actiondesk particularly delightful:
- No need to map each column in Google Sheets with each column from your data source, just choose the columns you need, an empty spreadsheet and dump all the data.
- If you add new columns in your initial source, Actiondesk will automatically spot that and create a new column in Google Sheets
- No need to set up multiple automations to handle record creation and record update.
Actiondesk will run every 10min and handle both new records and updated records.
How to get started:
- Fill up the signup form (takes <2min)
- Subscribe to one our plans or request a free demo
- Once you're in, go to Integrations, add your data sources and your google sheets account
- Build your first workflow 🚀
Here's a 1.30min tutorial showing how it works:
Looking forward to getting your feedback!
Really useful for non technical teams, makes an otherwise painful task very easy! 💪
How does it compare to Zapier?
The product looks nice (just by looking at the website, didn't try it), but the pricing seem to be very high. Zapier has plans in the range of $0-$125, while your cheapest plan is $150
Hey @danbars , thanks for your comment. With Zapier, you'd have to:
- create a zap for new records
- create multiple zaps for updated records when available (for example, Zapier doesn't handle updates for Airtable)
- If you had more columns in your source, you'd have to modify your zap and map the new column.
In short, if you just want to create new record from the source and do not care about updates (typically for data coming from a form), Zapier is great. Otherwise, it can be a bit manual and painful to implement.
@danbars Our (https://seekwell.io/) plans start at $49 and include hourly refreshes from SQL (MySQL, Postgres, SQL Server, Snowflake) to Sheets. We don't connect to other SaaS apps because in our experience most companies already have the data in SQL via Segment or something similar.
We're targeted at slightly more technical users (e.g. we need you to know a bit of SQL) and also support scheduling Python / Juptyer Notebooks, which can be really powerful in automating analytic workflows.
I have been struggling so many times while implementing CRM softwares (Salesforce.com, Microsoft analytics etc..) in the different sales organisations I worked for, mailny due to the diversity of legacy products and the numerous sets of data related to it we needed to integrate, that I would have love to be able to use the Actiondesk software in order to facilitate this huge process. Using Actiondesk for googlesheet to push data would have saved me and my team a lot of time and avoid pain during those transfers.
Would have been a great tool for me (a designer) who wants to pull real data into designs with Figma (via sheets), but I can't justify the monthly price. I suppose I'm probably not the target audience and usage, but hard to pass up as I can see its value for me.
Hi @simongabriel , thanks for your feedback and totally understand where you're coming from.
- Which data source would you like to pull data from?
- What would be an acceptable data point for you? It's always good to hear feedback about pricing :)
CryptoPoops