Google Sheets Connector
Google Sheets Connector Help
Version 4
ZappySys Logo File Version: v4
Supported Engine: 9

Authentication :: User Account [OAuth]


Description

No description available [Read more..]

Parameters
Parameter Label Required Options Description Help
UseCustomApp UseCustomApp YES Use your own app credentials or inbuilt app provided by ZappySys for ease of use. If you choose UseCustomApp=true then make sure to obtain your own ClientId and Secret using steps provided (Click [Steps to Configure] link found next to Authentication Type dropdown)
ClientId ClientId NO
ClientSecret ClientSecret NO
Scope Scope NO
SpreadSheetId Default SpreadSheetId NO
Option Value
Enter Your Sheet Id
Example Sheet Id 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
Enter default spreadsheet Id which should be used if user do not supply when calling various operations supported by this connector. To obtain sheet Id. Open spreadsheet in browser and check URL. You will example value like 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms that is your sheet id.
TabName Default Tab Name (i.e. Sheet1) NO Enter default tab name for spreadsheet Id you supplied. If you keep it blank then it will use first tab by default.
RetryMode RetryMode NO
RetryStatusCodeList RetryStatusCodeList NO
RetryCountMax RetryCountMax NO
Instructions This connection can be configured in two ways. Use Default App (Created by ZappySys) OR Use Custom App created by you.
To use minimum settings you can start with the ZappySys created App. Just change UseCustomApp=false on the properties grid so you dont need ClientID / Secret. When you click Generate Token you might see a warning about App is not trusted (Simply Click Advanced Link to expand hidden section and then click Go to App link to Proceed).

To register a custom app, perform the following steps (Detailed steps found in the help link at the end):

  1. Go to Google API Console.
  2. From the Project Dropdown (usually found at the top bar) click Select Project.
  3. On the Project Popup click CREATE PROJECT.
  4. Once the project is created you can click Select Project to switch the context (You can click on Notification link or Choose from Top Dropdown).
  5. Click ENABLE APIS AND SERVICES.
  6. Now we need to Enable two APIs one by one (Sheets API and Drive API).
  7. Search Sheets. Select and click ENABLE.
  8. Search Drive. Select and click ENABLE.
  9. Go back to the main screen of the Google API Console
  10. Click the OAuth Consent Screen tab. Enter necessary details and Save.
  11. Click the Credentials tab.
  12. Click CREATE CREDENTIALS (some where in topbar) and select OAuth Client ID option.
  13. When prompted Select Application Type as Desktop App and click Create to receive your ClientID and Secret. You can use this information now to configure Connection with UseCustomApp=true.