Skip to content

Check Record Existence in Google Table

Google Sheets integration with bot: checking information existence in Google table and instructions for working with "Check Record Existence in Google Table" block

The block allows you to check for information existence in Google Table.

You can find the document ID in the browser URL. Open Google Table in a new tab and copy the ID. Example: https://docs.google.com/d/ ID_HERE /edit

google sheets search

"Check Record Existence in Google Table" block

Access control in LEADTEX chat bots: checking users through Google Sheets

Video with a breakdown of the "Check Record Existence in Google Table" block functionality for creating chat bots with an access control system.

The lesson demonstrates creating a bot that checks user existence in the database and only allows authorized participants. Shows setting up integration with Google Sheets, creating contact lists, automatic user addition to the database and a moderation system with ban capability.

Go to LEADTEX constructor