App Icon
Pull data from any API into Google Sheets in seconds. SyncWith is the easiest way to integrate with all your favorite data sources via API.
Works with:
59,751
Overview
SyncWith is a completely free add-on for Google Sheets that makes it simple to query the data you want from 3rd party apis and services and update it on a schedule with sharing.

Using SyncWith you can automatically import all of your data into one place in Google Sheets, and easily summarize it, filter it, create pivot tables, chart it, and integrate it with other data.  You can build custom dashboards and reports, alters, query, join, sync and manipulate your data.  No more cut and pasting csv files, importrange or other difficult ways to combine data and spreadsheets.

Use SyncWith to export your data from many apps and integrations or any API including:
* Web analytics including Google Analytics, Mixpanel, Heap, Segment
* Performance marketing tools include Google Ads, Facebook Ads, Apple Search Ads, LinkedIn Ads, Microsoft Advertising, Adroll, Taboola, Google Ad Manager (GAM), Adwords
* Apple iTunes
* SEO, SEM and PPC tools like SEMRush, AHrefs, Moz, Google Search Console, Majestic SEO, Bing Services, Yandex
* Mobile ASO Tools like AppTweak, App Annie, SensorTower
* Ecommerce apps including Shopify, WooCommerce
* Email marketing tools including MailChimp, SendGrid, MailGun, Twilio, Unbounce
* Project management tools like Asana, Trello, Jira, ClubHouse, Airtable, Bitbucket, EasyVista
* Social sites including Pinterest, Quora, Instagram, Twitter, Reddit, Snapchat, Vimeo, YouTube, Hootsuite
* Salesforce, Stripe, PayPal, Hubspot, Amazon, GitHub, Wordpress, Zendesk, Pipedrive, Weebly
* Entrepreneurs tools like Craigslist, Angellist, Etsy, Patreon
* Connect to a database table from Google BigQuery, Postgres,Postgresql, MySQL, SQL, RDS, AWS, mongoDB, Redshift, Snowflake, Google Data Studio
* Tax and Accounting with Quickbooks, Xero, Freshbooks
* Pipedrive, Slack, Zoho, Dropbox, Heroku
* Also great for finance, bitcoin and crypto, tracking BTC, ETH at sites like CoinGecko, Binance, Ethermine, CoinMarketCap, CoinBase, MinerStat, FlexPool, CoinAPI, BitPay, BitStamp, BitFinex, Ethereum, CryptoCompare, CoinSpot, Cryptometer, SupportXMR, Poolin, Nanopool, Ethplorer,  CryptoWatch (CryptoWat.ch), PancakeSwap, BitKub, IndoDax, KuCoin, Coin Paprika, Nomics and other cryptocurrency and blockchain applications
* Pull in educational and classroom data with Google Classroom
* Other APIs including Dribble (or Dribbble), Strava, Spotify, Harvest, ParseHub, MoviDesk, NSEIndia, Upwork, Torn, HubAPI

You can use it as an API connector to create as many connections as you want, easily refresh connections daily and hourly to stay up to date or refresh real-time.  Get all of your data into one spreadsheet to perform cross-channel reporting, cohort analysis, data visualizations and more.

Recommended if you like other scraping & API connection tools like Postman, IFTTT, Insomnia, Zapier, and Supermetrics, Coupler, Simplescraper.  Your business can connect virtually any cloud server or platform to build and report on and monitor whatever you want.

Easily manipulate JSON, CSV and XML with dynamic JMES formatting.

Share projects across your domain, create templates to manage client data, campaigns and metrics, track ROAS, mfflove from excel into the cloud, derive insights instantly by merging data sources and sheets, backup and create changelogs, allow data integration without engineers - all no code, harness the power of other add ons like sheetgo, api connector, coupler.io, adstage.io, coefficient.io, merge sheets, supermetrics, archive data with a single free enterprise tool.

We also support advanced and generic APIs and databases via oauth.  Try out more esoteric APIs like Alloha.tv, Tracksale, Craftbeerpusher, Algoexplorer, AutoKontinent, Fatture, Julitec, Novadax, TD Ameritrade, Bergamo, Agoda, Yahoo, Open Weather Map, Visual Crossing, Sportradar, Yahoo Finance, Alpha Vantage, NSE India (NSDIndia), Onex Ultimo, FTX

Other services and APIs that can be implemented withSyncWith include: ActiveCampaign, Algolia, AngelList, Anymail, Apify, Autopilot, Aweber, Azure, Basecamp, Bing, Bitbucket, Bubble, Buffer, Calendly, Campaign Monitor, Capsule, Chargebee, Chatfuel, Clearbit, ClickFunnels, Constant Contact, ConvertKit, cPanel, WHM, Dandelion, DataBox, Discord, Disqus, Docupilot, Drip, Egnyte, Elasticsearch, EmailHippo, Etsy, Eventbrite, Evernote, Feedly, Fieldbook, Firebase, Flickr, Foursquare, FreshBooks, FinnHub, Freshdesk, Front, FTP, G2Crowd, GetResponse, GitLab, Google Maps, Gravity Forms, Harvest, Help Scout, HipChat, Hootsuite, HTTP, IFTTT, Indeed, Infusionsoft, Insightly, Integromat, Invoice Ninja, JIRA, Kickbox, KissFlow, Klaviyo, Knack, Leady, LionDesk, Listrak, Magento, Mailgun, Mandrill, ManyChat, Marketo, Mattermark, Mattermost, Medium, Meetup, MessageBird, Microsoft Teams, MongoDB, MonkeyLearn, Moosend, Moz, MyTimeStation, NetSuite, Ninox, OneDrive, OneNote, OpenAI, Paperform, Patreon, PayPal, Pinterest, Pipefy, Pipeline Deals, Pitchbook, Plivo, Plutio, Pocket, Podio, RAYNET, Rebrandly, Recurly, Redshift, RSS and Atom feeds, Runkeeper, Salesflare, Salesforce, ScheduleOnce, Segment, SendGrid, SendinBlue, SendPulse, Sendy, ServiceNow, SFTP, ShipStation, Shopio, SigParser, Slack, Smartsheet, SoundCloud, Spotify, SQL Server, Square, StackExchange, Streak, Stripe, SugarCRM, Survey Monkey, Teamgate, Telegram, Todoist, Toggl, Tumblr, Twilio, Twist, Twitch, Twitter, Typeform, Unbounce, Wasabi, Watson, Webflow, Weebly, Wild Apricot, WooCommerce, WordPress, Wrike, Wufoo, Wunderlist, Xero, YouTube, Zapier, Zendesk, ZeroBounce, Zoho, Notion, Wazirx and many more.

Additional information
Privacy policy
Terms of service
SyncWith | API | FREE | Import Exported JSON will ask for the permissions shown below. Learn more
SyncWith | API | FREE | Import Exported JSON will need access to your Google account
This will allow SyncWith | API | FREE | Import Exported JSON to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Justin O'Neill
July 22, 2021
Wow Wow Wow !
Is this review helpful?
Yes
No
Profile Picture
Jack Schimpf
June 30, 2021
I LOVE GOOGLE!!
Is this review helpful?
Yes
No
Profile Picture
Hien Pham
May 11, 2021
I don't normally leave reviews but I figured I would for this one. I needed to pull crypto data into one of my sheets and this one was by far the best and easiest one to work with. Plus, you can tell what data you want added. I tried Mixed Analytics and that was alright, but it's only free for a month. This one on the other hand is free!!
Is this review helpful?
Yes
No
Profile Picture
Tom McLellan
February 11, 2021
Easy way to import data directly to Sheets from a 3rd party API. I'm looking at how to import marketing analytics and ecommerce data (JSON data feeds) into Google sheets, instead of importing the same CSV every time we need a report. This looks simple but it works! It should help us automate our reporting so we can spend more time actually working on our marketing campaigns.
Is this review helpful?
Yes
No
Profile Picture
Kaus Pethe
April 18, 2021
After trying a number of other add ons I have found that this works perfectly. Great support from the devs too. Keep up the good work!
Is this review helpful?
Yes
No
Profile Picture
Marcus Duffy
May 6, 2021
Worked well with Google Maps API. Did what I needed and great support from the developer to help me get there. Thanks.
Is this review helpful?
Yes
No
Profile Picture
Siversmith
March 22, 2021
I have tried a number of different api import applications. This one easy to implement and although at first it didn't work exactly as I was expecting a follow up email from the developer prompted me to explain the issues. They proceeded to look at the information, make some adjustments and upload a new version within 2 day. This is hopefully the sign of a great company in the future. Excellent application and great response from the developers.
Is this review helpful?
Yes
No
Profile Picture
Soroush Khodaii
March 16, 2021
Great addon to import my google ads info along with google analytics to gauge performance on various campaigns down to the ad asset.
Is this review helpful?
Yes
No
Profile Picture
Steven Chiu
April 14, 2021
Easy to use with good support.
Is this review helpful?
Yes
No
Profile Picture
António Almeida
March 6, 2021
Worked just fine 9n every api that I tested. Great service and addon for gs.
Is this review helpful?
Yes
No
1-10 of 43
Search
Clear search
Close search
Google apps
Main menu