Track Stripe MRR in Google Sheets

Learn how to load your subscriptions into Google Sheets to calculate your MRR in your currency of choice

Calculate Rolling Averages with Array Formulas in Google Sheets

Utilize Google Sheets ArrayFormula and Sumif to calculate rolling sums and moving averages. Specifically how to track your MRR, daily MRR growth and MRR growth on a moving average basis.

Top Pages in Google Search Console

Use Google Analytics to understand where you’re getting traffic from and to which pages

How to use the Mailchimp Campaign Open Report

Learn how to use SyncWith to access your Mailchimp campaign open report.

Update your Shopify inventory availability by SKU

Get a template spreadsheet that shows how to use the Shopify API to adjust inventory levels at your store’s locations.

Track Pinterest ad account metrics

Learn how to use the Pinterest API to track your paid Pinterest ad performance.

Export LinkedIn analytics: followers, page views and shares

Learn how to use the LinkedIn API to export your organization’s number of followers, page views and shares.

Get your LinkedIn Organization URN

Many LinkedIn API calls require an ID known as your organization’s URN. Learn how to find your organization’s URN.

Get YouTube video views by traffic source type

Drill into the number of views each of your videos gets by the source of the traffic, for example advertising, external links and embeds.

Export Sales Orders from Unleashed

Learn how to export your sales orders from Unleashed to Google Sheets.

Export tickets from a Zendesk view

Zendesk can organize tickets into views; learn how to use SyncWith to export only tickets from the view you specify.

Get Tweet Engagement Metrics from Twitter API

Learn how to use the Twitter API to track tweet impressions, profile visits and link clicks.

Export data from Zoho Analytics API

Learn how to export data from Zoho Analytics API into Google Sheets.

How to find YouTube Channel ID

Many YouTube API calls require the YouTube channel ID. Learn how to find the channel ID for any YouTube channel.

Get YouTube subscriber counts and view counts into Google Sheets

Learn how to export statistics about YouTube channels, including subscriber, video and view counts, into Google Sheets.

Get a Wild Apricot access token

Wild Apricot’s API requires you to create an API key, and then exchange the API key for an access token. Learn how to get your access token.

Export your Facebook Ad Campaigns

Export your Facebook ad campaign configuration, including budget and remaining spend limits.

Export your Facebook Ad Creatives

Export metadata about your Facebook ad creatives, for example, to relate ad spend to Facebook post performance.

Track your Shopify inventory by SKU

Use Shopify’s GraphQL API to improve your business processes by automating reporting of your inventory in stock, broken out by SKU and location.

API Sports Google Sheets Overview

General overview of moving data from the API Sports api into Google Sheets

How to get a Notion API key

Learn how to get an integration API key to access your Notion database.

Connecting to Postgres or MySQL

Learn how to resolve ENOTFOUND and ETIMEDOUT errors when connecting SyncWith to your SQL database.

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

SEO KPIs: Landing Page Analysis

Analyzing landing pages with Google Search Console to improve SEO performance

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

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.

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

Connect your Shopify account

How to connect additional Shopify accounts

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 v3 to understand your top landing pages from Google organic search.

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.

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

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.