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

Binance Coin & Currency Pair Tracker Template

Track available coin and currency pairs from Binance

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.

Connecting SyncWith to your Google APIs

Connecting SyncWith to your Google accounts for the first time can be tricky. See a tutorial on how to connect it.

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

Connecting Notion tables to Google Sheets

Create a live connection from a Notion table(s) to Google Sheets using the SyncWith Google Sheets addon and the Notion API

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

Mailchimp campaign metrics into Google Sheets

In this tutorial we'll show how to track your Mailchimp campaign metrics including open rate, click through rate and more

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.

Creating Marketing KPIs

Beginners reference for setting up and creating marketing KPIs in Google Sheets using SyncWith.

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.

Export YouTube video engagement stats to Google Sheets

Do you run a YouTube channel? You can use the YouTube API to export all your videos and their likes, views, comment counts etc to Google Sheets using the SyncWith Addon

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.

Current Covid19 stats by country into Google Sheets

Here we'll use the free Covid19 API to get current stats on the coronavirus worldwide, by country, into Google Sheets, and using the SyncWith Google Sheets Addon it will be kept up to date automatically!

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.

SEO: Get your top landing pages from search

Use Google Analytics to understand your top landing pages from Google organic search.

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.

Installation Trouble

If you're having trouble installing the SyncWith Google Sheets Addon, it can often be caused by having multiple Google Accounts, read on to see how to resolve this

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 Salesforce Leads

Sync your salesforce leads with google sheets on a schedule using the salesforce API, Syncwith and SOQL (Salesforce Object Query Language)

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