Here you can find tutorials about using SyncWith's Google Sheets Addon, and articles showing how to get useful data out of 3rd party apps and services.
Google Analytics SEO Tracker Template
Utilize Google Analytics data to show trends for the top landing pages receiving traffic from Google organic search.
CoinGecko USD Coin Tracker Template
Track up to 15 coins with detailed information including price, pricing trends for the last year, 7d charts all in Google sheets
Connecting WooCommerce Orders to Google Sheets
Export and sync your WooCommerce customers, orders, and more to Google Sheets using the WooCommerce API with the SyncWith Google Sheets addon
Many Connections on a Single Sheet
Tutorial on how to ensure multiple API connections load data onto a single Google Sheet vs multiple sheets.
SEO KPIs: Landing Page Analysis
Analyzing landing pages with Google Search Console to improve SEO performance
Scheduled API Refreshes
How to setup your scheduled api refreshes into Google Sheets with SyncWith
How to combine new data with your existing sheet: replace, append or synchronize
SyncWith lets you specify how to combine new data from an API with existing data already in your sheet.
Facebook Page Metrics into Google Sheets
How to get your Facebook page(s) metrics including likes, comments, engagements, clicks, impressions into Google Sheets using the Facebook Graph API
Get Twitter user followers count into Google Sheets
Using the SyncWith Google Sheets Addon we can pull metrics from the Twitter API including follower count, following count and more, for one username, or a list of usernames from Google Sheets.
Listing Xero invoices
Xero requires a special header in most API requests. This tutorial tells you how to find your Xero-Tenant-Id value and call the Invoices API.
Service invoked too many times for one day: urlfetch
Google Sheets add-ons rely on certain Google services that have quota limits. Learn how to debug urlfetch quota problems.
Get student grades from Google Classroom
Learn how to export a spreadsheet of student grades from your Google Classroom account.
Get a Shopify API key
Learn how to get a Shopify API key to access your merchant data with SyncWith.
Pulling Airtable records into Google Sheets
Airtable is a popular app for managing tables of data. In this tutorial we'll show how to pull any of your tables into Google Sheets, keeping them in sync.
Getting detailed weather for a specific date into Google Sheets
Using the free API from MetaWeather we'll show you how to pull detailed weather data for a date in the past or future
Getting the weather forecast into Google Sheets
Using the free API from MetaWeather we'll show you how to get the weather forecast for the next 5+ days into Google Sheets and keep it up to date automatically.
Get crypto prices from CoinMarketCap
In this tutorial we'll show how to use the CoinMarketCap API to pull live crypto prices into Google Sheets
Google Search Console - Queries
Here we'll show how to use the Google Search Console API to pull a list of all your site's queries to get their clicks, impressions, CTR and position. We'll also show how to get stats for a single query, which you can then use with Cell References to pull stats on just the queries you care about.
YouTube Analytics in Google Sheets
The YouTube Analytics API lets you pull analytics data into Google Sheets to automate complex reporting tasks, build custom dashboards and more. You can pull data about a video channel, to find out key metrics including views, comments, likes, minutes watched, view duration, subscribers gained or lost, and you can segment it by video, or by time period such as day, week, month etc.
How to use paginated APIs
Some APIs use pagination to limit the amount of data in each request. You have to make repeated calls to get each "page" of results. SyncWith can do this for you automatically. We support most pagination styles: page-based, offset/limit-based, URL-based and cursor-based.
Yahoo Finance - Major Holders Breakdown
Using Yahoo Finance's undocumented API you can get a lot of information about a particular stock. If you want to get the Major Holders breakdown, to see what % of the shares are owned by insiders and institutions, you can request the module majorHoldersBreakdown
Intro YouTube video
This video is a brief introduction to the SyncWith addon, showing how to connect to an API to pull data, how to expand nested JSON data using our preview tool, and then get it into Google Sheets
Yahoo Finance - Getting Balance Sheet data
Learn how to use Yahoo Finance's undocumented API. Specifically we'll show how to use the SyncWith Addon to extract Balance Sheet financial data for any public company based on their stock ticker.
Get daily weather from OpenWeatherMap
Get a live weather forecast for the next 7 days in Google Sheets using the OpenWeatherMap free API.
Export a YouTube Playlist to a Spreadsheet
Do you have large YouTube playlist(s)? You can use the YouTube API to export your playlist of videos or songs to CSV or Google Sheets. We'll show how to do this, and how to have a live updating export in Google Sheets.
Instagram Followers Count
Do you want to stay up to date with your follower count on Instagram? You can use SyncWith to automatically pull your follower count and other key metrics into Google Sheets, giving you a live view of your metrics, enabling you report on it or even build it into a dashboard.
Cell references with Binance
In this article we'll show how to use the SyncWith google sheets add-on to import data from multiple requests to one API using Cell References. This is a great time saver, enabling you to create powerful datasets driven from data in your sheet