Data Writers
Google Sheets Writer
Node Inputs
data
: The data to be written to the Google Sheet. It should be a list of text.use existing google sheet
(Optional): A boolean value indicating whether to write to an existing Google Sheet (set totrue
) or to create a new one (set tofalse
).sheet link or id
(Optional): If using an existing Google Sheet, this should be the link to it in Google Drive or the sheet’s ID.sheet name
(Optional): The name of the specific sheet within the Google Sheet file where data will be written. If not provided, the first sheet in the file will be used.writer mode
: This specifies how you want the data to be written to the sheet. Options include “Add New Row”, “Add New Column”, “Add to Specified Row”, or “Add to Specified Column”.row index
(Optional): When adding data to a specified row, this is the index of the row, starting from 0.column index
(Optional): When adding data to a specified column, this is the index of the column, starting from 0.
Node Output
sheet link
: The link to the Google Sheet where the data was written.
Node Functionality
The Google Sheets Writer node allows you to automate the process of adding data to a Google Sheets file. Depending on the writer mode you select, you can add data as a new row or column, or append it to a specific row or column of an existing sheet. The node offers flexibility whether you’re starting from scratch with a new Google Sheet or updating an existing one.
When To Use
Use the Google Sheets Writer node when you need to:
- Automate data entry into a Google Sheet.
- Create new sheets or update existing ones with new data programmatically.
- Organize collected data into structured tables within Google Sheets.
- Share real-time data outputs by writing to a centrally accessible Google Sheet.