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.

Click

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: Records added anywhere in the middle of a worksheet. All the records followed by these newly added records.
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.

Browser not supported