Insert record

Learn how to use the insert record operation on your table by using a lead generation flow example.

Inserting a record on your table means that you will create a new row on your table.

This means that you'll go from this:

FullName	Email

To that:

FullName	Email
Agatha	[e-mail]

Insert a record

To insert a record on your table:

1. Make sure that you created a table with the appropriate structure. For this example, we will use a lead generation table that captures:

   • FullName: Captures the lead's full name.

   • Email: Stores the lead's email address.

An example of table for lead generation

2. Make sure that you capture the relevant variables in your conversation. In our example, we capture the user name and email in Collect input blocks. These are the variables that we want to add to our lead generation table, i.e. customer_name and customer_email.

3. Add a Table operation to your flow.

Add a Table operation to your flow.

4. Select Insert Record.

Select the Insert record table operation

5. Select the table that you'd like to work on. For this example, we called our table Lead generation.

Select your table.

6. To recall, our example lead generation table has 2 columns: FullName and Email. Under Operation Config, link the FullName field to be populated with the variable {customer_name}.

7. Do the same for Email and {customer_email}.

Insert a record to your table.

8. Click Save.

Test your bot

It's crucial to verify the functionality of your Insert Record operation to ensure data is captured and stored correctly:

1. Test your bot in the emulator. Run through your bot flow within the emulator to simulate the user experience and trigger the Insert Record action.

2. After testing, navigate to your table to confirm that the lead's information has been accurately recorded and stored.

---

Looking for a quick and easy bot template to play with Tables? The Gym bot is a representative use case.