Automate Multi-Platform Social Media Lookup from Google Sheets with Gemini AI

This n8n workflow automates the process of extracting social media handles for individuals listed in a Google Sheet using the power of Gemini AI via OpenRouter, and then stores the extracted information back into the Google Sheet.

What it does

This workflow streamlines the process of enriching contact data with social media profiles by:

1. Scheduling a Trigger: Periodically checks for new data to process.
2. Reading Google Sheet Data: Retrieves a specified number of rows from a Google Sheet.
3. Filtering Data: Processes only rows where the "Social Media" column is empty.
4. Executing a Sub-workflow: For each filtered row, it calls a sub-workflow to handle the AI-powered lookup.
5. AI-Powered Information Extraction: The sub-workflow uses an OpenRouter Chat Model (likely Gemini) to extract social media handles (e.g., LinkedIn, Twitter, Facebook, Instagram) from the provided name and company.
6. Updating Google Sheet: Writes the extracted social media information back into the corresponding row in the Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: With a spreadsheet containing a list of names and companies, and a column for "Social Media" to store the results.
• OpenRouter Account: An OpenRouter API key configured as a credential in n8n. This is used to access AI models like Gemini.
• Google Sheets Credential: A Google Sheets credential configured in n8n with access to your spreadsheet.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Ensure your Google Sheets credential is set up correctly and has access to the target spreadsheet.
   • Ensure your OpenRouter Chat Model credential is set up with your OpenRouter API key.
3. Configure Google Sheets Node (ID: 18):
   • Specify the Spreadsheet ID and Sheet Name where your data resides.
   • Ensure the "Social Media" column exists in your sheet for the output.
4. Configure Schedule Trigger Node (ID: 839):
   • Adjust the Interval to your desired frequency for checking and processing new data.
5. Configure Limit Node (ID: 1237):
   • Set the "Limit" value to control how many items are processed in each run. This is useful for testing or managing API usage.
6. Configure Filter Node (ID: 844):
   • Verify the condition {{ $json.SocialMedia === '' }} correctly targets the column you want to check for emptiness.
7. Configure Execute Sub-workflow Node (ID: 111):
   • You will need to create a separate sub-workflow that contains the Information Extractor and OpenRouter Chat Model nodes.
   • The sub-workflow should accept a name and company as input and return the extracted social media handles.
   • Ensure this node is configured to call the correct sub-workflow by its name or ID.
8. Activate the Workflow: Once configured, activate the workflow to start the automated process.