Google Spreadsheet Actions are defined in a similar way to Database Actions but without the Stored Procedure option.
The Google Spreadsheet functionality was enhanced in version 4.4 (July 2015) to include SELECT, INSERT, UPDATE and DELETE Actions. As a consequence there have been a few changes.
Prior to v4.4 only the READ Action was available
Existing Public Connections/READ Actions created prior to v4.4 can still be used in your app design and modified in the Connections Dashboard.
 |
Existing Private Connections/READ Actions created prior to v4.4 will no longer work unless they are made public. |
The first row in the worksheet will be treated as the header row.
|
If users modify the contents of the header row in a worksheet, an Action may break. |
 |
For a column to be accessible, it must have data in its header cell. Columns without data in the header cell are not exposed to the Action. |
The column name is case sensitive and must match the name of the column in the Google API.
|
The column names are the header values of the worksheet lower cased and with all non-alpha-numeric characters removed. For example, if the cell A1 contains the value "Time 2 Eat!" the column name would be "time2eat". |
|
If the Auto Complete feature is used you may still have to manually modify the Sheet Column names accordingly. |
The data exposed to the Action contains all rows after the first row up to the first blank row.
|
The first blank row terminates the data set. If expected data isn't appearing, check the worksheet manually to see whether there's an unexpected blank row in the middle of the data. In particular, if the second row of the spreadsheet is blank, then the Action will contain no data. |
See also: Text/CSV Connections, Connection and Action Permissions
Return to: Creating PerfectApps Connections, Integration
