Developer & DevOps

Automate Google Sheets data processing and API integration

8 nodes 193 105 Automatic trigger
Download

Workflow Description

A workflow that enables manual triggering of Google Sheets operations with custom code execution and HTTP requests to sync and export data to external systems seamlessly.

How it works

  1. 1.Activate the manual trigger to start the automation workflow
  2. 2.Execute custom code to transform and process spreadsheet data
  3. 3.Retrieve data from the designated Google Sheets document
  4. 4.Send HTTP requests to sync processed data with third-party applications

Use cases

  • Automatically update and synchronize spreadsheet data with external platforms without manual intervention
  • Extract data from Sheets and push it to APIs to streamline data workflow

Requirements

  • Active Google Sheets account with edit permissions on target spreadsheets
  • Basic knowledge of HTTP requests and structured data formats

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Google Sheets

Details

Trigger Automatic trigger
Nodes 8
Apps 1
Views 193
Downloads 105

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (8)

When clicking "Execute Workflow"

Manual Trigger

#1

Sticky Note

Sticky Note

#2

Authenticates to your Icypeas account

Code

#3

Sticky Note1

Sticky Note

#4

Sticky Note3

Sticky Note

#5

Sticky Note4

Sticky Note

#6

Reads lastname,firstname and company from your sheet

Google Sheets

#7

Run bulk search (domain-search)

HTTP Request

#8