Subscribe
Sign in
SyncWith for Google Sheets — Data from any app into Google Sheets, reports & dashboards
SyncWith is a Google Sheets Addon that lets you sync data from any app into Google Sheets.
Get access to your data, and bring all your data sources into one place. Build custom reports and dashboards. Marketing, SEO, Crypto, Stocks, eCommerce and more!
70
Replies
John Chan
Woah - thanks for making this, @waterlooalex! Loved the demo. Being able to references cells for API calls seems really, really useful.
We've actually been looking for something like this for some time now. We currently use the GA add-on and Databox to build out marketing dashboards. It's not the best set up and there are more powerful options, but we were turned off by their pricing—I won't say who :)
Happy to switch our tooling and share any feedback you need—can't wait dig in!
Share
@jtcchan Thanks for checking it out! Yes being able to reference values from cells in one of your sheets is one of our favorite features - you can use it to pull in a single dynamic value (for example a relative date, or a variable you can update), or any number of values in a column (for example stock tickers, or campaign names, or keywords) to get SyncWith to pull data once for each row.
Glad to hear you're already building out dashboards, they're such a powerful tool for this type of work! Looking forward to hearing any feedback you might have.
Hi Product Hunt! We're really excited to be launching here today 🎉
We started SyncWith because we saw the transformative power of being data driven at our previous businesses, but saw that many people hit road blocks getting access to the data they needed, and being unable to build reports and dashboards without knowing SQL or without waiting on an analyst.
We built SyncWith to solve this problem, to enable anyone who can use a spreadsheet to get access to the data they need to measure and report on whats important to them!
*Try it now for free:* https://syncwith.com
Since we published our Google Sheets Addon a few months ago, its been used by over 4,000 users to make over 12,000 connections to sync data from 1,000s of apps into Google Sheets.
Who can use SyncWith?
- Marketers building reports from Facebook Ads, Google Ads, Google Analytics, Instagram, YouTube and more
- Crypto and Stock investors, looking to track their portfolios and make investment decisions
- Founders running eCommerce stores and websites using Stripe, Shopify, Etsy etc
- SEOs who want to perform detailed analysis and build reports using data from Ahrefs, SEMRush, Moz, Google Search Console and Google Analytics
- Data curious people who want to get their data out of Strava, Google Calendar and more
- Anyone who has data locked away somewhere that wants to get access to it
*Try it now for free:* https://syncwith.com
This sounds like it will be great if I get it working, but what concerns me is the permissions requested by someone I don't know, permission to:
• Organise and delete your spreadsheets
• See the names and emails of people with whom you share your spreadsheets
Nobody know who may own SyncWith in the future, but I should give permission to edit and delete confidential data and to identify those who my sheets are shared with?!
Really great @waterlooalex
Product looks leaps and bounds above other options in the Sheets Addon marketplace!
- THE UX for digging into deeper levels of API data is on 🎯
- Ability to spin up just about any API on it
- Useful to just grab quick data mashups for fast insights!
Awesome free tool! Can't wait to see what other innovations you layer on to this!
@waterlooalex @jlogic thanks for the kind words!
Our goal was to hide as much complexity as possible while still exposing lots of capabilities for power users. Lots more to do on both fronts, but we're excited about where we're at already!
@giri Thanks Girdharee, really appreciate it. Let me know if you have any feedback or questions!
Very useful product. I used to subscribe to Zoho's BI tool just to build a few reports from Xero that I can now easily handle with SyncWith.
Congrats on the launch! I have been using it for a while - the product has improved so much, and 1K+ integration is just insane, keep it up!
@andrew_goldis thanks!! 1k+ integrations - a big thing we've been working on is lowering the cost/effort for us to have an integration, which is super exciting, and although many of these integrations are not (yet) as substantial as others, we still see them dramatically increasing the number of users who can actually get data out, which is our main goal.
@sakol_sudjai awesome, glad it could help you. Would love to hear a bit about how you hope to use it, too!
That drill-down UI is ✨! This is exactly the kind of rapid data mashup needed for much product management research.
@kris_braun Glad to hear it! Yeah we've found it invaluable so far dealing with all the varied shapes data comes in.
Nice! This looks like a huge time saver and much smarter at handling nested API data. The cell reference feature is brilliant, like a VLookup table for API calls. Look forward to giving this a try instead of manual CSV efforts. Thanks!
@thmclellan Great to hear Tom! Yeah please stop doing manual CSV work right away :).
I look forward to playing around with this a bit more. This sounds like this could be really helpful for a non developer like myself.
How can we suggest new integrations to add?
@brenden_sherratt1 glad to hear! We're always looking for feedback from our users on what integrations are most valuable for them. Based on that kind of feedback so far, we've already built integrations for Google Analytics, Google Ads, Facebook and Instagram, to name a few.
You can reach us at hello@syncwith.com, or via https://syncwith.com/support
OMG exactly what I have been looking for @waterlooalex and @colin_dellow Custom dashboards here I come ;) Nice work!
@waterlooalex @barry_lachapelle thanks Barry! Yeah, everyone needs a custom dashboard or two. :)
Congrats on the launch, that looks like a super useful product! 🤩
do I get it right that it can do the same thing as a Data Studio report but with less hassle? (tbh, I haven't done a single Data studio report, but our programmers do such reports for me, so I suppose some programming skills are needed in Data Studio)
@margarita_s88 Hey Margarita, thanks for checking us out! Yes, you can use us similarly to Data Studio. Lots of our users build dashboards just using us and Google Sheets.
Some of users use us _and_ Data Studio, though -- they use us to get data into sheets, then pull the sheet into Data Studio.
@eric_ang1 Amazing, thanks Eric! Great suggestion, we definitely plan to expand the scheduling options. SERanking would be a good one to integrate for sure - I imagine if you have some time/energy to read their API docs you can get it working, and we'd be happy to help with that.
I am particularly fond of personalisation and customisation when looking for an app, software or basically anything. I love how much the user can customise like delete unwanted columns, select specific data and stuff like that.
I would love to see you guys, @AlexBlack, work with Microsoft and make a kind of similar app/add-on for MS Excel.
Keep up the good work guys!
@guptaakshitaa Fantastic, yeah feel similarly and hope to keep improving the customization aspect.
We've definitely been looking at building an addon for MS Excel too, I see they have a very similar web sdk that can be used to build a single addon for both Office 365 online excel and desktop excel.
@guptaakshitaa thanks Akshita! We definitely have our eye on integrating with a few other platforms, and Excel is right up there.
I love the idea of how just anyone with google sheets can implement any data from any source into the spreadsheet so efficiently. The neatness and the integration itself is what makes this pretty good. I am particularly loving the feature of transferring even nested data from a site to my spreadsheet without going to and fro and copying and pasting etc etc. Using Google Sheets before using @SyncWith was tiring and overly time consuming. Much Appreciated!
@syncwith @gupta_ayushh thanks, Ayush! We put a lot of behind the scenes effort into that nested data feature, so hopefully it "just works" most of the time. (But when it doesn't, we'd love to hear from you, so we could make it better!)
?makers Very cool product, I love google sheets and I scripted something similar to this a while ago to pull tweets and other livestream data for a project and this would have saved me a lot of time. What is the pricing model for Syncwith?
@mohamed_habib1 Awesome, glad to hear you like it! Yes thats a fantastic use for SyncWith, pulling live data from Twitter. I hope SyncWith can save you time in the future.
Pricing model - currently its completely free, we plan to always have a free tier, but will be adding a paid plan in the coming weeks. We don't totally know yet how it will work, sorry thats not a great answer. We've seen other similar products charge a few different ways, one charges if you want to automate refreshes, another charges based on rows refreshed.
I have had way too often in my life a request to present data that is provided via an API in JSON format as Google sheets to be used in operations/sales. It was always a tedious, manual work. Now I can just refer to this! Awesome!
@ioah ha ha, I think I might know some of what you're referring to. :) thanks, Albert!
Congrats on the launch, @waterlooalex. Ever since import.io promised this a while ago (10 years, maybe?!), i've been looking for a tool that can actually handle and transform web data to a useable content. Really looking forward to using this in more detail in the coming weeks - I'll be sure to pass on feedback as it comes!
@waterlooalex @bertie thanks, Bertie!
We don't natively support scraping data from web sources, but we do see a lot of users asking for this and using services like simplescraper.io in the meantime to get an API that they can use with us.
@waterlooalex @colin_dellow for sure - most of the time I need a simpler request anyway, so I think SyncWith will be a really useful resource!