Collect YouTube Channel Stats and Contact Info with Google Sheets and SERP API

This n8n workflow automates the process of extracting YouTube channel statistics and contact information. It's triggered by new rows added to a Google Sheet, fetches relevant data using the SERP API (likely for YouTube search results or channel details), processes this information, and then updates another Google Sheet with the collected data.

What it does

1. Triggers on new Google Sheet rows: The workflow starts whenever a new row is added to a specified Google Sheet. This sheet is expected to contain YouTube channel URLs.
2. Fetches YouTube channel data via SERP API: For each new YouTube channel URL, it makes an HTTP request to the SERP API to retrieve detailed statistics and potentially contact information related to that channel.
3. Processes and transforms data: The collected data from the SERP API is then processed and transformed using a Code node and a Set node. This step likely extracts specific fields, formats the data, and prepares it for storage.
4. Updates Google Sheet: Finally, the processed YouTube channel statistics and contact information are appended as new rows to another Google Sheet, providing a centralized and organized database.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: With access to create and modify spreadsheets.
• Google Sheets Credentials: Configured in n8n for both the Trigger and Google Sheets nodes.
• SERP API Key: An API key for a SERP API service (e.g., SerpApi, Google Search API, etc.) that can retrieve YouTube channel data. This will be used in the HTTP Request node.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Google Sheets Trigger:
   • Select your Google Sheets credential.
   • Specify the Spreadsheet ID and Sheet Name where you will add new YouTube channel URLs.
   • Set the "Trigger On" option to "New Row".
3. Configure HTTP Request (SERP API):
   • Update the URL, headers, and body of the HTTP Request node to match your chosen SERP API's documentation for fetching YouTube channel data.
   • Ensure your SERP API key is included, typically as a header or query parameter.
   • The input to this node will likely be the YouTube channel URL from the Google Sheets Trigger.
4. Configure Code & Edit Fields (Set) nodes:
   • Review and adjust the JavaScript code in the "Code" node and the field mappings in the "Edit Fields" node to correctly parse and extract the desired data from the SERP API response. This will depend on the exact structure of the SERP API's output.
5. Configure Google Sheets (Output):
   • Select your Google Sheets credential.
   • Specify the Spreadsheet ID and Sheet Name where the collected data should be written.
   • Set the "Operation" to "Append Row".
   • Map the data from the previous nodes to the columns in your output Google Sheet.
6. Activate the workflow: Once all configurations are complete, activate the workflow.

Now, whenever you add a new YouTube channel URL to your input Google Sheet, the workflow will automatically fetch its stats and contact info and add them to your output Google Sheet.