Skip to content
Nappai Documentation

Spread Sheet

Spread Sheet works with Google Sheets spreadsheets as whole files and with their tabs: create a new spreadsheet, add tabs to it, look up its details, rename it, duplicate it from a template, clear its content or delete it.

To read, add or change rows inside a tab, use Sheet Cells.

When to use it

  • Every month you want to create a copy of your report template named after the month.
  • When you sign up a customer, you want to create a spreadsheet for them with the Orders and Invoices tabs.
  • Before loading the day’s data, you want to clear the tab where it goes.
  • You want the list of spreadsheets in your account or the tabs of one of them.

Configuration

You need a Google Sheets credential, which connects by signing in with your Google account. To create, change or delete, the credential needs the Create, Update, Delete, Read access; with Read Only you can only look things up. See Credentials.

FieldWhat it does
Credential (required)The Google Sheets credential of the account you work with.
OperationWhat the component does. See Operations. Default: Create SpreadSheet.
Mode of InputIn every operation except Create SpreadSheet, how you point to the spreadsheet: By Selection shows a picker to choose it from your Drive; By Id asks for its ID; By Url asks for its link. Default: By Selection.
Select Spreadsheet / Spreadsheet ID / Spreadsheet URLThe spreadsheet you work with, depending on Mode of Input. Required except in Get, where leaving it empty returns your spreadsheets.
Spreadsheet NameOnly in Create SpreadSheet. The name of the new spreadsheet. Required.
New Spreadsheet NameIn Update, the new name of the spreadsheet. In Duplicate SpreadSheet, the name of the copy. Required in both.
Sheet NameIn Create SpreadSheet and Create Sheet, the name of the tabs created. You can add several. Required in Create Sheet.
Select SheetIn Get, Clear and Delete, the tab you work with, or All SpreadSheet for the whole spreadsheet. The list loads when you choose the spreadsheet; click the refresh button if it doesn’t appear.

Operations

OperationWhat it does
Create SpreadSheetCreates a new spreadsheet. If you fill in Sheet Name, it is created with those tabs instead of the default tab.
Create SheetAdds one or more tabs to an existing spreadsheet.
GetReturns the details of a spreadsheet and its tabs, of one tab only, or the list of your spreadsheets if you choose none.
UpdateRenames a spreadsheet.
Duplicate SpreadSheetCreates a copy of a spreadsheet named after New Spreadsheet Name. This is how you use a template.
ClearClears the content of one tab, or of all of them with All SpreadSheet. The tabs are kept.
DeleteDeletes a tab. With All SpreadSheet it deletes the whole spreadsheet.

Advanced options

FieldWhat it does
Include DataOnly in Get. Also includes the content of the cells. Default: off.

Output

The Data output returns the spreadsheet you worked with: its ID, name, link (spreadsheetUrl) and list of tabs. In Get with no spreadsheet chosen you get one item per spreadsheet. In Duplicate SpreadSheet it returns the ID and name of the copy. In Clear and Delete, a confirmation of what was cleared or deleted.

You can use the ID in Sheet Cells to write rows, or connect the result to an email component to send the link. The component can also be connected to an Agent as a tool. See Tool Mode.

Example

A finance team prepares its report every month from a template.

  1. Schedule the flow for the 1st of every month. See Scheduler.
  2. Add Spread Sheet with the Duplicate SpreadSheet operation and choose the template in Select Spreadsheet.
  3. In New Spreadsheet Name put Report followed by the month.
  4. Connect the Data output to Sheet Cells to write the month’s data in the copy.

Good practices

  • Clear cannot be undone from the flow. If in doubt, duplicate the spreadsheet first with Duplicate SpreadSheet.