n8n: Google Sheets - Append row in sheet

Prerequisite

• Create - Google OAuth2 API
• Enable - Google Drive API
• Enable - Google Sheets API
• Credential - Google Sheets account

Create Spreadsheet
1) Go to https://docs.google.com/spreadsheets
2) Click - Blank spreadsheet

3) Change - File Name (1)
4) Define column in Sheet1

• Name
• Email
• Tel

n8n Workflow
1) Go to n8n website
2) Create workflow
3) Add first step - On form submission

4) Form Title: New User

5) Add Form Element

Field Name: Name
Element Type: Text
Required Field: Enable

6) Add Form Element

Field Name: Email
Element Type: Email
Required Field: Enable

7) Add Form Element

Field Name: Tel
Element Type: Text
Required Field: Enable

8) Click - Execute step (1)

9) Fill form
10) Click - Submit
11) Close

12) Click - X (or press "esc" on keyboard)

13) Click - + (1)
14) Search - Sheets (2)
15) Click - Google Sheets (3)

16) Search - (1)
17) Click - Append row in sheet (2)

18) Choose - Google Sheets account (1)
19) Choose - Document (2)
20) Choose - Sheet (3)
21) Drag - Name > Name (4)
22) Drag - Email > Email (5)
23) Drag - To > Tel (6)
24) Click - X (7)

25) Click - Save (1)
26) Click - Execute workflow (2)

27) Fill form
28) Click - Submit (1)

29) Check - Google Sheets Spreadsheet

30) Completed