SyncWith
p/syncwith
Get your data into Google Sheets
Ben Lang

SyncWith for Google Sheets — Data from any app into Google Sheets, reports & dashboards

Featured
70
•
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!
Replies
Best
Margarita Shvetsova
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)
Colin Dellow
@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.
Ian
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?!
Bertie IP
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!
Colin Dellow
@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.
Bertie IP
@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!
Mohamed Habib
?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?
Alex Black
@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.
Akshita Gupta
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!
Alex Black
@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.
Colin Dellow
@guptaakshitaa thanks Akshita! We definitely have our eye on integrating with a few other platforms, and Excel is right up there.
Vadym Shcherbakov
Great product! It is always hard to sync your data with Google Sheets and it is impossible to work without it nowadays. Great job! Congrats on the launch!
Alex Black
@vadim_shcherbakov Thanks for checking out SyncWith! We're working hard to continually make this simpler - it should be easy to pull the data you need into Google Sheets, and in the future we hope to do the same for Excel, Airtable, Google Data Studio and more.
Alex Black
Hey Eric, that's a great idea, we love airtable and hope to get SyncWith working with AirTable at some point!
ayush gupta
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!
Colin Dellow
@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!)
Alex Black
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
Caleb Del Begio
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.
Colin Dellow
@caleb_delbegio love to hear stories like that, thanks Caleb!
Andrew Goldis
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!
Colin Dellow
@andrew_goldis awesome, thanks for being an early supporter, Andrew! :)
Alex Black
@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.
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!
Alex Black
@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.
Josh Ho
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!
Colin Dellow
@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!
Barry Lachapelle
OMG exactly what I have been looking for @waterlooalex and @colin_dellow Custom dashboards here I come ;) Nice work!
Colin Dellow
@waterlooalex @barry_lachapelle thanks Barry! Yeah, everyone needs a custom dashboard or two. :)
Brenden Sherratt
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?
Colin Dellow
@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
Eric Ang
Awesome product! I have suggestion to increase schedule option to weekly, bi-weekly & monthly. Also hopefully you can integrate with SERanking.com that will be awesome.
Alex Black
@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.
Steve Lionais
This looks great. @waterlooalex it looks like your app has a lookup for API's that you support? Is that right?
Alex Black
@slionais Thanks!! Yes, you can search all the supported APIs and data sources by keyword or name, and if you know the API hostname or endpoint you can type or paste those in too
Ajmal khan
Tried the product in my google sheet. After installing, the product showed up on addon. But when it is selected - showing cannot connect to google sheet
Colin Dellow
@ajmal_khan4 hey Ajmal, thanks for checking us out! That sounds like a known Google limitation when a person is using multiple accounts :( https://syncwith.com/tutorials/i... describes the issue and a workaround you can try. Sorry for the hassle!
Albert Heinle
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!
Colin Dellow
@ioah ha ha, I think I might know some of what you're referring to. :) thanks, Albert!
Tom McLellan
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!
Alex Black
@thmclellan Great to hear Tom! Yeah please stop doing manual CSV work right away :).
Sean Daniel
Cool product Alex. You know someone once said that every start up should start with a spreadsheet MVP. This will Be a must have app for any start up. Plus you’ve changed the game for fantasy sports players. All the winners keep spreadsheets. Nice work! Congrats on the launch.
Colin Dellow
@sean_daniel thanks Sean! We've been blown away by some of the things our users have built. There's a community of Ford truck enthusiasts using us to track manufacturing delays on their new builds, down to the hour, all collaborating in the open. Can't wait to see what the fancy stats folks get up to!