Google Sheets

For programmatic access and automation:

1. Go to Google Cloud Console
2. Create a new project or select an existing one
3. Enable the Google Sheets API in Library
4. Go to Credentials and create an API Key
5. Restrict the API key to Google Sheets API only
6. Copy the API key to xpander.ai’s Google Sheets connection settings
7. Set appropriate API access restrictions in Google Cloud Console

​

Let’s create the Xpander.ai Google Sheets interface!

This app is using basic authentication.

To configure it in xpander.ai, follow the following screenshot:

Then save the interface.

For more information about the Google API enablement, click here.

For programmatic access and automation:

1. Go to Google Cloud Console
2. Create a new project or select an existing one
3. Enable the Google Sheets API in Library

The simplest way to connect Google Sheets is using xpander.ai’s built-in authentication:

1. Go to the Apps section in xpander.ai dashboard

2. Select Google Sheets from available integrations, and now you have two options:

   2.1 Click Sign in with Google Sheets:

   Select your Google account and grant permissions.

   2.2 Click other auth options, and fill in your Interface name, interface access, Set Authentication mode as OAuth2.

   Now click Sign in with Google Sheets:

   Select your Authentication scope, and save the interface.

3. Your connection is immediately active and ready to use.