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

Using Google Analytic 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

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