Google Sheets connection
You can seamlessly integrate Google Sheets with Data Integration to streamline data transfer and management processes.
Prerequisite
A valid Google account with authorized access to Google Sheets.
Establish a connection in Data Integration
Procedure
-
Navigate to the Data Integration Account.
-
Click Connections and select + New Connection.
-
Choose Google Sheets.
-
Assign a name to your connection.
-
Click Connect with Google.
note
- If nothing happens after clicking the Connect with Google button, your browser has blocked the pop-up:
- On the right side of the URL in your browser, click the pop-up blocked button.
- Select Always allow popups from Data Integration.
- Click again on the sign in with Google button, and a pop-up to connect to Google appears.
- Connect to the relevant Google account.
- Click Allow to enable Data Integration access to the data you wish to extract.
- Click Save to save the connection in your Data Integration account.
- Click Test connection. If the test is successful, you can begin working with Google Sheets.