n8n
Reporting
SEO
Google Search Volume Data for SEO Keywords in Google Sheets
Requirements
This n8n template automates the process of retrieving Google Search Volume Data and directly populating your Google Sheets. Eliminate the tedious task of manual data entry and save valuable time on your keyword research. Simply input your list of target SEO keywords into a Google Sheet, and the template handles the rest.
Gain instant access to crucial search volume metrics, empowering you to make informed decisions for your content strategy.
Workflow Steps
This automated workflow follows a simple, yet powerful sequence:
1. Manual or Scheduled Trigger
Initiate this workflow manually with a click, or configure it to run automatically on a schedule, such as the first day of each month, providing flexibility for your needs.
2. Google Sheets Data Input
Connect your Google Sheets account with the necessary credentials and select the spreadsheet containing your SEO keywords. The “Top queries” column is crucial, as it holds the keywords.
3. Data Extraction
A function node extracts the keywords from the “Top queries” column and transforms them into an array, preparing the data for the Google Ads API request.
4. Google Ads API Communication
The HTTP Request node connects to the Google Ads API, requiring you to input your Google Ads credentials, customer ID, and developer token. This node then retrieves search volume data for each keyword.
5. Data Splitting by Keyword
A Split Out node separates the API response data by keyword, enabling easier management and processing of individual keyword results.
6. Google Sheets Data Output
The workflow appends or updates the Google Sheet with the search volume metrics for each keyword.
Requirements
To get started, you’ll need:
Permissions to access data from your Google Sheets account.
Access a Google Ads Test Account and its Customer ID for API use.
Permissions to access and manage your Google Ads account.
Access a Google Ads Developer Token for for account management.
Still have questions about this workflow automation template? Get help from our community of users and experts.
n8n is the perfect platform to bring this template to life. With its intuitive visual interface, you can easily connect your accounts, customize the workflow, and schedule automated reports.
© 2025 No Bad Content OÜ. All rights reserved.
