Integrate your chatbot with Google sheets to record all user inputs (variables) in a Google sheet.
Add your Google Account to your Promptchat account
![](https://forum.promptchat.com/assets/files/2023-07-10/1688983797-185238-addgoogleaccount.png)
Prepare a Google Sheet
This will record all the user inputs (variables) which the chatbot collects during the conversation flow.
Here is an example where we simply collect 4 variables (First & Last names and Email and Phone numbers). Don’t forget to rename the Sheet too at the bottom.
![](https://forum.promptchat.com/assets/files/2023-07-10/1688983820-206568-sheet.png)
Go to the Chatbot builder and insert the Google Sheets block
Here is an example of the simplest ever Lead Generator chatbot which collects all user input into a Google Sheet.
![](https://forum.promptchat.com/assets/files/2023-07-10/1688983850-243791-blockgs.png)
Configure your Google Sheets block in the chatbot builder
![](https://forum.promptchat.com/assets/files/2023-07-10/1688983869-131964-builder.png)
Once complete, check back regularly for new data collected by your chatbot or set up automations via Zapier / Integromat etc...