(5/5)

Googlesheets Workflow

Automated workflow: Googlesheets Workflow. This workflow integrates 11 different services: filter, stickyNote, code, scheduleTrigger, set. It contains 34 nodes and follows best practices for error handling and security.

Integrations Used (4)

Workflow Structure (26 nodes)

100%

Schedule Trigger

Every hour

Filter

Don't email on weekends

Set

Settings

Set

Email sequence

Stop And Error

Error Handler

Google Sheets

Get emails

Filter

To email?

Set

Prepare first message params

Code

Package placeholder values

Execute Workflow

Call message send sub-workflow1

Google Sheets

Update last contacted time

Gmail

Get previous message threads

Execute Workflow Trigger

Set

Set message template

Gmail

Get thread details

Code

Fill message placeholders

Code

Decode messages

Set

Compose message

Code

Classify threads

Filter

Next message due?

Replying?

Gmail

Send new message

Set

Prepare reply params

Gmail

Reply to message

Code

Decode placeholder values

Execute Workflow

Call message send sub-workflow

Node Types:

action

transform

code

default

logic

trigger

Requires credentials

Prerequisites

Required Credentials (2)

Gmail

Used by: Get previous message threads, Get thread details +2 more

Docs

Google Sheets

Used by: Update last contacted time, Get emails

Docs

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~45 min

Score: 75/100

Custom Code

Conditional Logic

7 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Scheduled Operations

Run automated tasks at specific times - daily reports, weekly cleanups, monthly backups.

Set it and forget it - reliable automation that runs on your schedule.

workflow.json

{
  "meta": {
    "instanceId": "workflow-f9c09b25",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:42.514174",
    "updatedAt": "2025-09-29T07:07:42.514194",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "nodes": [
    {
      "id": "8565747a-4108-4467-98e4-f57d441f66af",
      "name": "Update last contacted time",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2380,
...