Get search volume metrics for a range of keywords in Google Sheets.

<aside> 💰 Uses 150 credits. 1 request = 1,000 keywords.

</aside>

How to use the formula

=searchvolume(range, location, format, period, header)

1. Range

With the range argument you can select the range of keywords you’d like to get search volume data for. Functions in Google Sheets time out after 30 seconds, so we recommend you only select a range up to a maximum of 3,000 rows.

1 request = 1,000 keywords. If you select a range lower than this number, you will still use 1 request (150 credits). That’s because keywords are requested in batches of 1,000 to our API provider.

<aside> 💡

</aside>

2. Location

There are over 50,000 locations you can get search volume data for your keywords. From cities, regions and countries from across the world.

The default value is set as “United Kingdom”.

You can also input the location as Global to get total search volume data across all countries.

Countries There is data for 214 countries:

Cities & Regions