Various Authentication Support

Sheet Director connects with Applications, through various authentication mechanisms

Some popular authentication mechanism that Sheet Director supports are

OAuth2
OAuth1
Key Authentication
Username/ Password
Credentials

OAuth 2.0 Authentication

Authenticate securely with modern cloud applications using OAuth 2.0 without sharing your passwords.

Popular applications using OAuth 2.0 include:

Google Workspace
Microsoft 365
HubSpot
Salesforce
Zoho CRM
Xero
QuickBooks
Airtable
Many other cloud applications

Benefits

Secure token-based authentication
No password storage
Easy authorization and reauthorization
Industry-standard security
Automatic access token management

OAuth 1.0 Authentication

Sheet Director also supports OAuth 1.0 for applications that continue to use the OAuth 1.0 protocol.

Benefits

Secure signed requests
Compatible with legacy APIs
Trusted authentication mechanism
Reliable API communication

Sample OAuth Authentication

App Configuration

Connect to Capsule CRM

Follow these simple steps to securely connect Capsule CRM with Google Sheets using Sheet Director:

Click Connect to Capsule to start the authentication process.
You will be redirected to the Capsule CRM authorization page.
Sign in to your Capsule CRM account if prompted.
Review the requested permissions and confirm access.
Click Allow to authorize the connection.
Once authorized, you'll be redirected back to Sheet Director, and your Capsule CRM account will be connected successfully.

After the connection is established, you can securely import, export, and synchronize Capsule CRM data with Google Sheets, enabling automated workflows and bi-directional data synchronization.

After authentication Success message will shown
Close that window and you can use the service

API Key Authentication

Many REST APIs use API Keys instead of OAuth. Sheet Director lets you securely configure API Key authentication for these services.

Benefits

Quick setup
Easy configuration
Secure API access

Sample Key Authentication

App Configuration

Provide you API Key
Click on connect to Insightly to connect to Insightly so that you can pull data.

Obtain Your API Key

For applications that use API Key authentication, you'll need to generate or retrieve your API key from the application's account settings.

Example: Retrieving an API Key from Insightly

Sign in to your Insightly account.
Click your profile icon in the top-right corner.
Select User Settings from the menu.
Scroll down to the API Key section.
Copy your API key.
Return to Sheet Director and paste the API key into the authentication field.
Save the connection to securely authenticate and start syncing data.

Once the API key is configured, Sheet Director can securely connect to Insightly, allowing you to import, export, and synchronize data between Insightly and Google Sheets.