Save data to Google Sheets

Google Sheets is a great tool to store and process data. With Fchat, you can push customers’ information provided via Webform / User Input to Google Sheets for storage and processing.

To save customer information to Google Sheets, in the Message Block update window, click More >> Save Data to Google Sheets

save-data-to-google-sheets

save-data-to-google-sheets

You can push data from Fchat to an existing worksheet by entering the Google Sheet ID or creating a new one by clicking on Google Sheet Connection.

save-data-to-google-sheets

1. Save the data to an existing worksheet

You can aggregate the data obtained from multiple Message Blocks into one worksheet by entering the ID of that worksheet into Fchat.

Condition: The worksheet is shared in Edit mode.

save-data-to-google-sheets

The worksheet ID is described as shown in the image below. Copy this ID and place it in the Sheet ID box in Fchat and select the variables in the order you want in Google Sheet.

save-data-to-google-sheets

save-data-to-google-sheets

The screen will display as shown below when the connection is successful.

save-data-to-google-sheets

2. Save the data to a new worksheet

You need to connect Fchat to a Google Sheet document in your Gmail account.

save-data-to-google-sheets

Next, choose the account connected to Fchat: 

save-data-to-google-sheets

In the Google message as shown below, select the Advanced option: 

save-data-to-google-sheets

Then, click Go to fchat.co (unsafe):

save-data-to-google-sheets

Select Allow for Fchat to connect to your Google Sheets account

save-data-to-google-sheets

So you can connect Fchat to Google Sheets. 

Finally, add a list of the information you want to save to Google Sheets such as {full_name}, {email}, {phone}...

Then you can open GoogleSheet to see a list of saved data.

save-data-to-google-sheets

At Google Sheet, you can change the sheet’s name, or delegate staff members to process new orders. 

Wishing you a successful business with Fchat!

×