How to Append a Row in Google Sheets in n8n

‍

‍

It is very easy to append a row in Google Sheets in n8n. Here’s a quick guide on how to do it in simple steps:

‍

1. Inside your n8n workflow, click the 'Add' button to create a new step.
2. After that, click 'Action in an App'.
3. Find and select 'Google Sheets' from the list of options.
4. Under the Sheet Within Document Actions section, tap 'Append Row in Sheet'.
5. Now, it's time to configure the selected node. To get started, click the 'Credentials' menu and select the Google account that contains the spreadsheet you want to edit.
6. As for the Resource and Operation, make sure that 'Sheet Within Document' and 'Append Row' are selected respectively.
7. Tap the 'Document' menu afterwards and choose the spreadsheet you want to edit.
8. Subsequently, click the next menu and select the sheet you want to edit.
9. Specify how you wish to map the columns. Click on its corresponding menu and choose one from the given choices.
10. Provide the values you want to add to your spreadsheet.
11. Once done, click 'Execute Step' to proceed.
12. Finally, the selected Google Sheets row will be appended according to your input.