Sheets

​

Description

Integrate Google Sheets to automatically send and manage your users’ contact information who log in to your app/website using OTPLESS.

​

Overview

The Google Sheets connector allows you to seamlessly integrate Google Sheets with your application. This connector enables you to send user data to a Google Sheet, helping you manage and review your contacts efficiently.

​

Benefits

• Centralized Contact Management: Automatically create and update contacts in a Google Sheet.
• Improved Data Organization: Leverage Google Sheets to organize and analyze your user data effectively.
• Enhanced Data Accessibility: Access your user data from anywhere with Google Sheets.
• Automation: Streamline your workflows by automating the process of adding users to your Google Sheet.

​

Prerequisites

• A Google account with access to Google Sheets. If you do not have one, you can sign up at Google Account Signup.
• Access to the OTPLESS app for configuring the connector.

​

Activation Steps

1. Log in to OTPLESS:

   • Open the OTPLESS app and log in with your credentials.

2. Navigate to Connectors:

   • In the dashboard, go to the Connectors section.

3. Choose Google Sheets Connector:

   • From the list of available connectors, select “Google Sheets.”

4. Activate Connector:

   • Click “Activate” to add the Google Sheets connector to your list of active connectors.

5. Link Google Account:

   • Click on the “Link Account” button.
   • Follow the prompts to log in to your Google account and authorize OTPLESS to access your Google Sheets.
   • After linking, you will be shown the URL of the Google Sheet where the contacts will be created.

​

Connector Configuration

1. Access Google Sheets:

   • Log in to your Google account and open Google Sheets if you haven’t done so during activation.

2. Review in OTPLESS:

   • Go back to the OTPLESS app.
   • In the Google Sheets connector settings, review the URL of the Google Sheet where the contacts will be created, which is auto-filled after the connection is successful.

​

Connector Testing

1. Verify Contact Creation:

   • Log in to your app/website using OTPLESS to trigger the connector.
   • Check your Google Sheet to verify that the contact has been created and the user data is correctly populated.

2. Check Logs:

   • Monitor the logs in both OTPLESS and Google Sheets for any errors or issues with the data synchronization.

​

Troubleshooting

• Account Linking Issues:

  • Ensure you have authorized OTPLESS to access your Google account and Google Sheets.
  • Re-link your account if necessary.

• Contact Creation Problems:

  • Verify the configuration settings in OTPLESS.
  • Check if there are any restrictions or limits in your Google Sheets.

• Configuration Errors:

  • Double-check all configuration settings in OTPLESS and Google Sheets.
  • Refer to Google’s documentation for additional troubleshooting tips: Google Sheets Documentation.

By following this documentation, you should be able to effectively integrate and manage your user contacts using the Google Sheets connector within OTPLESS.