Automated Google Search Console Reporting to Airtable - n8n Workflow

• SEO Analysts and Consultants who require scheduled, accurate reporting without manual CSV handling.


• Digital Marketing Teams needing an updated database of performance metrics for quick dashboard creation.


• Website Owners looking for a clean, non-GSC interface to monitor clicks, impressions, CTR, and average position.


• Users searching for efficient n8n templates to handle marketing data extraction and storage.

Manually downloading, cleaning, and aggregating data from Google Search Console is a significant time sink for anyone involved in SEO. This specialized n8n workflow eliminates that inefficiency by creating a robust, scheduled integration. This automation pulls three critical dimensions of data—Query (keywords), Page (URLs), and Date (daily performance)—for your specified domain and time period. By utilizing the n8n node structure for splitting and renaming fields, the workflow ensures that data arriving in Airtable is perfectly clean and instantly reportable. This n8n workflow provides tremendous value by transforming raw API results into an actionable SEO database, allowing users to build complex dashboards directly in Airtable.

This automation follows a precise, multi-branch structure initiated by an n8n trigger:

1. Schedule Trigger: The entire process begins with the Schedule Trigger, ensuring the n8n workflow runs automatically, typically daily or weekly, based on configuration.


2. Define Variables: A Set n8n node establishes the key parameters: the target domain (e.g., funautomations.io) and the reporting days (default is 30 days).


3. Parallel API Calls (GSC): The workflow executes three parallel HTTP Request calls targeting the Google Search Console API using the predefined domain and date range. These calls fetch data dimensioned by 'query', 'page', and 'date'.


4. Split Data: Since the API returns data in a large 'rows' array, a Split Out n8n node is immediately used in each branch. This action transforms the array into individual items, ensuring that each keyword, page, or date record is processed separately.


5. Clean and Map Fields: Subsequent Set n8n node configurations (Edit Fields) clean up the temporary API field names. For example, the keys[0] field (which holds the keyword, page URL, or date) is renamed to a more suitable column header like 'Keyword' or 'page'. Other metrics like clicks, impressions, ctr, and position are preserved.


6. Airtable Storage: Finally, the clean data items are sent to three dedicated Airtable n8n node instances. Each instance creates a new record in its corresponding table ('Queries', 'Pages', 'Dates') within the designated Airtable base, completing the data synchronization for this powerful n8n template.

To deploy this n8n workflow, follow these steps:

1. Import: Copy the provided JSON code and import it into your n8n instance as a new workflow.


2. Google Search Console Credentials: You will need a Google OAuth2 credential configured for the Google Search Console API (Webmasters API). Ensure the API is enabled in your Google Cloud Project.


3. Airtable Credentials: Set up an Airtable Personal Access Token credential.


4. Configure Domain: Locate the 'Set your domain' n8n node (Set node) and update the domain value to your target website URL (e.g., sc-domain:example.com). Adjust the days parameter if you need a shorter or longer reporting window.


5. Airtable Setup: In the three 'Create a record' Airtable n8n nodes, ensure the Base and Table names (Queries, Pages, Dates) match the structure of your target Airtable base.


6. Activate: Save the n8n workflow and set the Schedule Trigger to 'Active' to begin automated synchronization.

This comprehensive n8n workflow relies on several core n8n node types to achieve data integration:

Schedule Trigger: Serves as the primary n8n trigger, initiating the data pull at recurring intervals (e.g., daily).
Set (Set your domain): A utility n8n node used to centrally define the variables (domain, days) which are dynamically used in subsequent HTTP Request nodes.
HTTP Request (Get query/page/date Report): These three nodes perform authenticated API calls to the Google Search Console API. They are configured with dynamic dates and utilize the dimensions parameter ('query', 'page', or 'date') to request specific report types.
Split Out: Essential flow control n8n node used immediately after the API call. It iterates over the main rows array returned by GSC, ensuring each individual record is processed sequentially.
Set (Edit Fields): These cleanup n8n nodes map and rename the raw API fields (like keys[0]) to user-friendly column headers ('Keyword', 'page', 'date') before writing to the database.
Airtable (Create a record): The final three n8n node actions. These connect to Airtable using a personal access token and perform the 'Create' operation, inserting the cleaned performance metrics into the appropriate 'Queries', 'Pages', or 'Dates' table.