Before building any integration flow you must at first configure the app from inside the Google Developers Console.
API & Service
page and enable the following:
Credentials
section and create a new credential of type OAuth client ID
.
Web application
https://{your-tenant-address}/callback/oauth2
In case of new domain you may get message like This app isn't verified
. Please refer to this doc to check how to proceed:
https://support.google.com/cloud/answer/7454865?hl=en
Here are the environment variables to configure for the component to connect with the Google API:
Following environment are required:
OAUTH_CLIENT_ID
- oauth App IDOAUTH_CLIENT_SECRET
- oauth App SecretTENANT_DOMAIN
- your Google API tenant domainREQUEST_TIMEOUT_PERIOD
- If you want to slow down requests to your API you can set delay value (in ms) and the component will delay calling the next request after the previous request.
Time for the delay is calculated as REQUEST_TIMEOUT_PERIOD
/ REQUEST_TIMEOUT_QUOTA
and shouldn’t be more than 1140 seconds (19 minutes due to platform limitation).
The current values of this variables can be found in Google documentation.
The REQUEST_TIMEOUT_PERIOD
value by default is 100000 (100 sec).REQUEST_TIMEOUT_QUOTA
- the field can be used in pair with REQUEST_TIMEOUT_PERIOD
, default to 500.Please note: if result quota restriction will be less than 1 request/min component
Retrieve Sample
task won’t be complete
Please Note: From the platform version 20.51 we deprecated the component
LOG_LEVEL
environment variable. Now you can control logging level per each step of the flow.
To get these please use the Google Developers Console. As a callback please use https://your-tenant.address/callback/oauth2
.
Recommended environment variable:
EIO_REQUIRED_RAM_MB
- recommended value of allocated memory is 512
MBThe technical notes page gives some technical details about Gspreadsheet component like changelog and completeness matrix.
Google Spreadsheet works with OAuth2 app configured at your Google Developer Console. To Authenticate the component you only need to press the button Authentication and the process would take you to Google to log-in and give permissions to the platform to access your Spreadsheets.
Google Spreadsheets component includes the following triggers:
The following Google Spreadsheets triggers are deprecated:
deprecated
- please use Get Spreadsheet Row trigger.
The Rows trigger reads the data in each row of a given Google Spreadsheet and passes it to the next stage of your integration flow.Google Spreadsheets component includes the following actions:
Create New Spreadsheet action Action to create a new Google spreadsheet.
Add Spreadsheet Row action Action to create a new Google spreadsheet row.
Add Row(deprecated) action
This action is deprecated
- please use Add Spreadsheet Row action.
Here are some general recommendations to help you avoid potentially confusing cases where you might get unexpected results while using Google Spreadsheets connector.
Depending on your Google Account settings your Google Drive and especially
Google Spreadsheets would have some specific default formatting applicable to
the Account Language/Country Setup in use. By default, Google will assume US
formatting which would mean not only the default currency is US Dollar ($
) but
also, the date format will be of MM/DD/YYYY
format, not DD/MM/YYYY
which is widely used in European and other countries.
Please note if the data you are planning to write has values in different language/country formatting than your Google Spreadsheets then you are most likely to encounter unexpected results.
Make sure to change it to the desired one in the Google Spreadsheets in advance
by selecting File > Spreadsheet Settings ...
menu of your Spreadsheet.
Do NOT change the Spreadsheet structure while your flow is active
If you make structural changes to the Google Spreadsheet while it is being used it will cause a number of Errors and the flow will stop functioning properly.
Decide the structure of your spreadsheet file in advance and avoid making any structural changes during the integration. In particular, avoid adding or removing additional columns since you would need to repeat the flow design process to properly map or link your changes.
If you still wish to change the structure of your Google Spreadsheet then follow these steps:
Do NOT insert a row between the records while your flow is active
If you insert a new row between existing structure the system would fail to recognize it as an update. Instead, this will cause the system to lose the connection between the unique IDs and the records since our unique ID is the row number.
If you wish to insert a row between existing records then you must first stop the integration flow in your Dashboard and then proceed to make the changes in your Google Spreadsheets file. You can activate your flow after you made the necessary changes. However, we recommend not to insert a row between the records even if you have deactivated it.
New inserted row will cause an additional data transfer
Avoid inserting a row in between the records during the integration since it would look different for the system. This would trigger an additional data transfer since not only the newly inserted row will be regarded as a new record but everything after the inserted row would be considered a new data.
Click here to learn more about the elastic.io iPaaS