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.

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 {:target= blank .external link} and [List of ISO 3166 country codes](https://en.wikipedia.org/wiki/List of ISO 3166 country codes){:target=_blank .external link} 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 , and RANDBETWEEN 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 {:target=_blank .external-link} for more information about these options.

Refer to the Method: spreadsheets.create | Google Sheets{:target=_blank .external-link} 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 .

Refer to the Method: files.delete | Google Drive{:target=_blank .external-link} API documentation for more information.