2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Make Sure you have a valid Google Account. For more information, follow the steps below.

Limitations


  • While syncing data from Google Sheets make sure the data in the form of the Tabular Report.
  • While Writing into Google Sheets and if you have the column names for mapping, make sure the column names are present in the first row of the sheet.

Connector Configurations

A Google Sheet API connector instance represents a single Google Spreadsheet access, including login credentials. If a user wishes to connect to multiple instances, he/she needs to create a separate connection for each of the instances.

The parameters required to opening the connection to a Google Sheet API user instance are:

Property

Description

Required

Username

The username to connect to Google Spreadsheet Instance

yes

Password

The password to connect to Google Spreadsheet Instance

yes

After a connector is created within a project, set up the connector within the process, DBSync can map to and from virtually any system using the Google Sheets API connector to retrieve data from or send data to databases. 

...

Q: Can I get a trial of DBSync?

A: DBSync is available free for 14 days trial after going through the Signup process

Q: Is this connector available with on-demand or on-premise Version?

A: This profile is available with both on-demand and on-premise Version.

Q: What are the type of  reports supported by DBSyncWhile syncing it is necessary the data should be in the form of Tabular Report?

A: Only Tabular reports of Salesforce you can sync with your databases, Google Sheets and many more. Yes

Q: How many records we can fetchspreadsheets of Google Account can be made in One connection?

A: Only the first 2,000 records we can fetch at the time of Integration One Spreadsheet Connection is allowed.