Google Sheets

Google Sheets is a cloud-based spreadsheet tool that supports data organization, analysis, and collaboration. 

Integrating your application with Google Sheets revolutionises data management, offering powerful spreadsheet functionality for streamlined organisation, analysis, and collaboration. 

Authentication

Ensure you have the following information ready for a seamless integration process:

• Connection Name: Select a descriptive name for your connection, like "MyAppsheetsIntegration". This helps easily identify the connection within your application or integration settings.

• Authentication Type: Google Sheets supports service accounts and OAuth authentication for server-to-server integrations. This would allow admins to take actions within Google Sheets without user interference.

Service Account

• Create a service account by following these steps.

• Add domain-level access to the service account (based on client ID) by following these steps.

• Ensure that the following scopes are added to your service account and domain-level access:

  • https://www.googleapis.com/auth/spreadsheets

  • https://www.googleapis.com/auth/drive

  • https://www.googleapis.com/auth/drive.file

• Use the service account email, private key, and a sample user email to authenticate the connection.

  
  

OAuth

• Press the Authorize button. You'll be redirected to a Google sign-in page.

• If you're not already logged into Google, enter your Google account credentials.

• Google will display a permissions request screen. You'll see our app name and the specific Google services we request access to (e.g., Google Drive and Google Sheets).

• Carefully review the permissions we're asking for. If you're comfortable with the permissions, click the "Allow" or "Grant Access" button.

• After granting access, you'll be automatically redirected back to our platform. You should see a confirmation message that your Google account is now connected.

  
  

Actions

Triggers