Google Sheets Document operations#
Use this operation to create or delete a Google spreadsheet from Google Sheets. Refer to Google Sheets for more information on the Google Sheets node itself.
This node can be used as an AI tool
This node can be used to enhance the capabilities of an AI agent. When used in this way, many parameters can be set automatically, or with information directed by AI - find out more in the AI tool parameters documentation.
Create a spreadsheet#
Use this operation to create a new spreadsheet.
Enter these parameters:
- Credential to connect with: Create or select an existing Google Sheets credentials.
- Resource: Select Document.
- Operation: Select Create.
- Title: Enter the title of the new spreadsheet you want to create.
- Sheets: Add the Title(s) of the sheet(s) you want to create within the spreadsheet.
Options#
- Locale: Enter the locale of the spreadsheet. This affects formatting details such as functions, dates, and currency. Use one of the following formats:
en
(639-1)fil
(639-2 if no 639-1 format exists)en_US
(combination of ISO language and country).- Refer to List of ISO 639 language codes and List of ISO 3166 country codes for language and country codes. Note that Google doesn't support all locales/languages.
- Recalculation Interval: Enter the desired recalculation interval for the spreadsheet functions. This affects how often
NOW
,TODAY
,RAND
, andRANDBETWEEN
are updated. Select On Change for recalculating whenever there is a change in the spreadsheet, Minute for recalculating every minute, or Hour for recalculating every hour. Refer to Set a spreadsheet’s location & calculation settings for more information about these options.
Refer to the Method: spreadsheets.create | Google Sheets API documentation for more information.
Delete a spreadsheet#
Use this operation to delete an existing spreadsheet.
Enter these parameters:
- Credential to connect with: Create or select an existing Google Sheets credentials.
- Resource: Select Document.
- Operation: Select Delete.
- Document: Choose a spreadsheet you want to delete.
- Select From list to choose the title from the dropdown list, By URL to enter the url of the spreadsheet, or By ID to enter the
spreadsheetId
. - You can find the
spreadsheetId
in a Google Sheets URL:https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0
.
- Select From list to choose the title from the dropdown list, By URL to enter the url of the spreadsheet, or By ID to enter the
Refer to the Method: files.delete | Google Drive API documentation for more information.