Operations For Operations Managers Advanced Community

Enrich Company Data From Google Sheet With Open AI Agent And Scraper Tool

Automated workflow: Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool. This workflow integrates 13 different services: webhook, sticky...

Importing this blueprint? Follow the n8n guide — credentials, test runs, and common pitfalls.

Open import docs →
Time Saved 8 hours/week
Setup Time ~20 minutes
Platform n8n
Run Cost Free Tier
Connected Apps:
Google Sheets Http Request Execute Workflow Trigger Split In Batches Sticky Note Set Markdown Webhook

Download Integration Assets

Import this community-sourced blueprint into your n8n dashboard. Review nodes and credentials before going live.

Download Blueprint

Connected Apps

Google SheetsHttp RequestExecute Workflow TriggerSplit In BatchesSticky NoteSetMarkdownWebhook

Interactive Workflow Canvas

Drag nodes vertically to re-order execution sequence. Edit or add steps to customize your blueprint.

Execution Steps

  1. Get rows from Google Sheet

    Processes and automates operations via the Google Sheets integration.

    Google Sheets

  2. Update Company's Row on Google Sheet

    Processes and automates operations via the Google Sheets integration.

    Google Sheets

  3. ScrapingBee : Scrape company's homepage data

    Processes and automates operations via the Http Request integration.

    Http Request

  4. Tool called from Agent

    Processes and automates operations via the Execute Workflow Trigger integration.

    Execute Workflow Trigger

  5. Loop Over Items

    Processes and automates operations via the Split In Batches integration.

    Split In Batches

  6. Sticky Note

    Processes and automates operations via the Sticky Note integration.

    Sticky Note

  7. Set company url

    Processes and automates operations via the Set integration.

    Set

  8. Finalize Pipeline Processing

    Runs the remaining 2 actions to complete the workflow.

    n8n

Optimize your tech stack and automate workflows between Google Sheets, Http Request, Execute Workflow Trigger, Split In Batches, Sticky Note, Set, Markdown, Webhook natively.

This verified AI automation workflow blueprint runs on n8n and enables real-time data syncs, content generation, or notifications without writing complex code.

Prerequisites

  1. An n8n account (self-hosted or Cloud)
  2. API access keys and credentials for: Google Sheets, Http Request, Execute Workflow Trigger, Split In Batches, Sticky Note, Set, Markdown, Webhook

Setup Guide

  1. Download Blueprint: Click the download button above to get the raw JSON file.
  2. Import to n8n: Open your n8n canvas, click settings in the top-right, and choose Import from File. Upload the JSON file.
  3. Configure Node Credentials: Double-click each node representing Google Sheets, Http Request, Execute Workflow Trigger, Split In Batches, Sticky Note, Set, Markdown, Webhook and authenticate with your account credentials.
  4. Activate Scenario: Test the flow manually by clicking Test step on the trigger, verify the output, then toggle the workflow to Active to start running.

Did this blueprint work for you?

AI integrations change fast. Help keep recipes accurate.

Related Blueprints

More n8n Blueprints

Recommended for Operations Managers