Developer & DevOps

Automate Google Sheets

14 nodes 3 1 Scheduled trigger
Download

Workflow Description

أتمتة Google Sheets

Service Value

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

Apps Used

Graphql Google Sheets

Details

Trigger Scheduled trigger
Nodes 14
Apps 2
Views 3
Downloads 1

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 (14)

/

Every day at 06:00

Schedule Trigger

#1

Get all your team's tickets

Graphql

#2

Sticky Note1

Sticky Note

#3

if has next page

If

#4

Get end cursor

Set

#5

Get next page

Graphql

#6

Sticky Note

Sticky Note

#7

Split out the tickets

Split Out

#8

Sticky Note2

Sticky Note

#9

Set custom fields

Set

#10

Sticky Note3

Sticky Note

#11

Sticky Note4

Sticky Note

#12

Write tickets to Sheets

Google Sheets

#13

Flatten object to have simple fields to filter by

Code

#14