Updates to our pricing plans

Hello, API Connector users! Over the past several years we've released hundreds of updates to API Connector, including the visual field editor, new integrations, new report styles, and dozens of other features, all designed to make connecting to APIs simpler and more convenient for reporting in Google Sheets. While most features have always been available on all plans, ... Read more

Get Your YouTube Content Owner ID

Typically, a YouTube Content Owner account is used to manage many different channels. YouTube's API requires the associated YouTube Content Owner ID for access to certain revenue-related metrics. Here is how to fetch this ID: Method 1: Get the ID from the YouTube's Developer Docs Method 2: Get the ID from the URL This method ... Read more

Google Ads/Analytics Geo Target Ids

This is the current list of country codes used by Google Analytics and Google Ads. These are also known as Geo Target IDs. List of IDs Geo ID Name Country Code 2004 Afghanistan AF 2008 Albania AL 2012 Algeria DZ 2016 American Samoa AS 2020 Andorra AD 2024 Angola AO 2010 Antarctica AQ 2028 Antigua ... Read more

List of YouTube Video Category IDs

This is the current list of YouTube video category IDs: 1 Film & Animation 2 Autos & Vehicles 10 Music 15 Pets & Animals 17 Sports 18 Short Movies 19 Travel & Events 20 Gaming 21 Videoblogging 22 People & Blogs 23 Comedy 24 Entertainment 25 News & Politics 26 Howto & Style 27 Education ... Read more

Find a YouTube Channel ID

A YouTube channel ID is a unique identifier for a YouTube channel. In recent years YouTube has moved to channel names instead of IDs, and it's now often impossible to find a channel ID by simply browsing around YouTube's website. However, the unique ID is still very important for fetching public data like view and ... Read more

Google Sheets: Convert Unix Timestamps to Dates

Certain APIs and datasets accept or display data in Unix epoch timestamps, which are not natively recognized by Google Sheets and can therefore not be used for calculations or other data transformations. These timestamps can be converted as follows, substituting in your date cell where you see A2. Array formulas are also provided for converting ... Read more

Big List of Free and Open Public APIs (No Auth Needed)

An API (Application Programming Interface) allows you to send and receive data from a remote server, like querying a database. This is helpful when you're building an app or pulling metrics for reporting, because it means you can focus on presenting information in a unique or useful manner, rather than developing the underlying data set. ... Read more