Step 1) Access Google Cloud Console and create a project
•
After logging in to https://console.cloud.google.com/, create a new project
•
Enable "Google Sheets API" and "Google Drive API"
Step2) Create a service account and issue a key
•
Click IAM & Admin > Service Accounts > Create Service Account
•
Role is given as "Editor" or "Spreadsheet Editor"
•
Key type is generated after selecting JSON and saved locally
Step3) Spreadsheet sharing settings
•
Open the Google Sheet document and share it with edit permissions to the service account email you created (e.g. xxx@project.iam.gserviceaccount.com ).
Now ready to integrate Google Sheets in n8n! 💪
Now let's look at each node's function.
📌 Scenario-based node function description
✅ Step 1: Create a spreadsheet and sheet
1. Create Spreadsheet (Create a spreadsheet document)
•
Function : Create a new Google Sheet file on Google Drive.
•
Input value : title (document title)
•
Output values : spreadsheetId , spreadsheetUrl
•
Example Node : Create Spreadsheet
2. Create Sheet
•
Feature : Add a new sheet (tab) to an existing Google Sheet document
•
Input values :
◦
DocumentId : ID of the generated document (uses the output value of the previous node)
◦
Title : Name of the sheet to be created
•
Output values : sheetId , title , index
•
Example Node : Create Sheet
✅ Step 2: Add Data
3. Append Row
•
Function : Add a new row of data to the sheet.
•
Input values :
◦
DocumentId : Document ID
◦
SheetName : Sheet ID or name
◦
Columns : Mapping of data fields to be added ( id , name , email , notes , country , created )
•
Data Source : Data loaded from Customer Datastore (n8n training) node
•
Example Node : Append Row
✅ Step 3: View and edit data
4. Read Sheet (Search rows with specific conditions)
•
Function : Find rows that match a condition within a sheet
•
Input values :
◦
DocumentId , sheetName
◦
FiltersUI : Example) Find the row with id "23423532"
•
Output value : row information including row_number , name , email , etc.
•
Example Node : Read Sheet
5. Update Sheet (Data Modification)
•
Function : Modify data in the retrieved row
•
Input values :
◦
MatchingColumns : Criteria columns (e.g. id )
◦
Columns.value : Content to be modified ( name , email , country , etc.)
•
Example Node : Update Sheet
✅ Step 4: Condition-based deletion and initialization
6. Read Sheet_ (Conditional lookup for deletion)
•
Function : Find data with specific conditions (e.g. country = US )
•
Output value : Obtain the row_number of the row to be deleted
•
Example Node : Read Sheet_
7. Delete Row
•
Function : Delete rows based on specific row_number
•
Input value : startIndex = $json.row_number
•
Example Node : Delete Row
8. Clear Sheet (Delete all values)
•
Function : Delete all data in the sheet and reset to a blank sheet.
•
Example Node : Clear Sheet
✅ Step 5: Delete a sheet or entire document
9. Remove Sheet (Delete the sheet itself)
•
Function : Delete a specific sheet (tab) within a spreadsheet.
•
Example Node : Remove Sheet
10. Delete Spreadsheet (Delete Spreadsheet File)
•
Feature : Delete entire document from Google Drive