SyncWith - Any API to Power BI

Overview of SyncWith’s free Power BI connector.

SyncWith - Any API to Airtable

Overview of SyncWith’s Google Sheets addon to enable any API to be synced to Airtable

Google Analytics UA vs GA4

Learn more about Google Analytics 4 (GA4), it’s pros and cons, why and how it differs from GA3 and how to take advantage of it.

Mailchimp Marketing API

The mailchimp marketing apilets

Google Ads API

Quick overview of the Google Ads API and the ability to live test the API.

BeMob API

Overview of the BeMob API and how to push your ad tracking and affiliate metrics into separate data sources such as Google Sheets for analysis

HubSpot CRM API

Learn about the HubSpot CRM API (api.hubapi.com) and all the various endpoints available to filter, sort, search, update and create HubSpot objects: contacts, deals, products, tickets, etc.

YouTube Analytics API

Get detailed engagement metrics for your YouTube channels and video sync’d from the YouTube API to your platform of choice.

GoHighLevel API Overview

Overview of the the HighLevel API and how to sync you GoHighLevel data to google sheets, excel and other data destinations.

Facebook Ad Strategies and Funnels

In depth guide to creating successful ad funnels with Facebook ads - tracking performance and scaling campaigns.

How to Drive Good ROAS on Facebook

Overview of return on ad spend and how to track, measure and increase ROAS of your Facebook Ads

Facebook Ads Connector for Power BI

Learn how to install and use the Facebook Ads connector for Microsoft Power BI.

JSON Placeholder API

JSON Placeholder API is perfect for when you need placeholder json. If you need fake json for users, posts or todos this the right placeholder api.

Keepa API

Utilize the keepa api, the amazon price tracker to pivot, filter and analyze price data

Metaweather API

Learn how to use the free weather api - metaweather. Create a weather dashboard and meta weather api alternatives.

SaaS APIs

Overview of popular SaaS APIs including Zendesk, Trello and Pipedrive

Yahoo Finance API Guide & Examples

Overview of the Yahoo Finance API including examples, live testing and endpoint overviews

Report which web pages get the most traffic and highest engagement

Overview of how to track web page engagement in Google Sheets.

Connect GA4 to Google Sheets

Overview of how to connect and sync Google Analytics v4 to Google Sheets

Connect Google Analytics to Google Sheets

Overview of how to connect and export Google Universal Analytics data to Google Sheets via the Google Analytics v3 API.

Shopify Admin API GraphQL Overview

Overview of how to connect to the Shopify Admin API via the GraphQL endpoint with a focus on retrieving orders

Connect Facebook Ads to Google Sheets

Overview of how to connect and export facebook leads and facebook ad data to Google Sheets via the facebook API.

Connect Shopify Products API to Google Sheets

Overview of how to connect and export Shopify products to Google Sheets via the Shopify API.

Facebook to Sheets API Guide

Overview of SyncWith’s Facebook APIs, templates and general guidelines on facebook audience and ad analytics to Google Sheets.

Connect Instagram Post Insights to Google Sheets

Overview of how to connect and export Instagram post data to Google Sheets via the Instagram Post Insights API.

Connect Shopify Orders API to Google Sheets

Overview of how to connect and export Shopify order to Google Sheets via the Shopify API.

Connect Facebook Page Insights API to Google Sheets

Overview of how to connect and export facebook leads and facebook ad data to Google Sheets via the facebook API.

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.

Facebook Ads API

Our comprehensive guide to how to use the Facebook ads API. Learn how to get data from the Facebook insights API, the ads API and the leads API.

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

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.