Google Spreadsheets allows you to access, create, and edit your spreadsheets wherever you go from your phone, tablet, or computer.
For more information, click here.
Field (Account) Information
While configuring the Source or Destination of a Template or Transaction, you need to create an account to connect Google Spreadsheet with Adeptia Connect. While creating an account, you need to specify the location from where Adeptia Connect will access the data.
If you are already logged in to your Google account on your browser, you will be asked to allow Adeptia Connect. In addition, if you have already configured your Google account within Adeptia Connect for Google Spreadsheet application, the system automatically displays that account name.
to add an account.
Specify the following information for Google Spreadsheet:
Click Continue.
Field Name | Description |
|---|---|
| User ID | Username to login to your Google account. |
| Password | Password to login to your Google account. |
Triggers
A Trigger specifies when a particular Transaction will start executing. While configuring the Source of a Template, you need to choose an event.
Following triggers are available for Google Spreadsheet at Source.
Trigger Name | Description | |
|---|---|---|
All Spreadsheets | Extracts all the existing Google spreadsheets. | |
| New Spreadsheet | Triggers when a spreadsheet is created. | |
| Download Worksheets | Downloads specified worksheet. | |
| New Records | Triggers when a record is added to the bottom of a worksheet. The system also considers the record that comes to the last position, due to an update in the middle of a worksheet as new. | |
| Updated Records | Triggers when a record is updated in a worksheet. The system considers the following records as updated:
| |
| New or Updated Record | Triggers when a record is added or an existing record is updated in the worksheet. It means, your connection will trigger even when the system rearranges a row that you are not updating. | |
Actions
An Action specifies how the data will be transferred at the destination location. While configuring the Destination (Target) of a Template, you need to choose an action.
Following actions are available for Google Spreadsheet at Destination.
Action Name | Description |
|---|---|
Delete Worksheet | Deletes worksheet from a Google spreadsheet. |
Add Records to Worksheet | Adds records to a specific worksheet of a Google spreadsheet. |
| Update records to Worksheet | Updates records of a specific worksheet of a Google spreadsheet. |
| Upsert records to Worksheet | Create or update records of a specific worksheet of a Google spreadsheet. |
With some actions (Update and Insert), you need to further specify the criteria based on which the records will be filtered:
- Select the Spreadsheet that you want to process
- Select the Worksheet that you want to process
Select the column whose value will be used to update the records. The following example demonstrates this:
Say you have employees data in a spreadsheet, which has columns Name and Salary. If you wish to update the salary of a particular employee, Adam, then select its corresponding column, Name.
Tips
While using Google Sheets with Adeptia Connect, you need to be careful about a few things. If you don't set up your spreadsheet in a specified way, there are chances that you do not get the intended results.
Following are the things that you must consider while using Google Sheet to optimize it for use with Adeptia Connect:
- The first row must have column headers.
- The second row must have content for the columns. Minimum one content row is required.
- There can be no completely blank rows before the end of your spreadsheet.
You must add rows or records to the end of the spreadsheet. As the new records here means the last record in the list.