Skip to main content

​
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.
⌘I