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.
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
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 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.
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.
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
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)
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