in order to perform a successful connection to you Google Sheet, we just need the following information and that's it!

  1. Valid Username and Password: We need an Username and password who has access to the Google Sheet where your data is located.

Once we have a successful connection, it will enable us to populate your AlertFind instance with the information you have in the Google Sheet such as:

  • Display Name
  • Email
  • Personal Email
  • Mobile Phone
  • Home Phone
  • Work Phone
  • Department
  • Location
  • State
  • County
  • Zip Code
  • And any other information you wish to add into AlertFind

How does our Google Sheets Connector works.

The below graphic explains the various nodes involved in the transition of data from your Google Sheet to AlertFind.

Detailed Steps Explaining Above Graphic:

  1. Google Sheets connector fetches the User information stored in your instance via API.
  2. Based on your chosen frequency, our connector running on AWS Lambda, fetches data from Google Sheets.
  3. At this stage, data goes through the validation and processing and finally transformed into a CSV.
  4. The CSV is compressed to a Zip file and sent to AlertFind API via the AlertFind Connector running on AWS Lambda.

Data Storage Nodes in Above Graphic:

  1. Node 5: Refers to Apache Cassandra Cluster which store the data for execution purposes. It has a TTL of 7 days after workflow execution has finished.
  2. Node 6: Refers to Elastic Search Cluster used for indexing data for 30 days so that it can be searched within the logs interface
  3. Data Safety: All data is encrypted in transit via HTTPS, using TLS 1.3 encryption internally. Sensitive customer data, such as access tokens, username, passwords are encrypted at rest using Amazon Key Management Service (KMS) which uses FIPS 140-2 validated hardware security modules.

We encourage you to keep searching the connector that suits your needs in our main AlertFind Connector List under the section System of Records Integrations by clicking the button below.

Did this answer your question?