Save form responses to Google Sheets

​

Before you begin

• A Google account that can edit the destination spreadsheet.
• A destination Google Sheet and a worksheet intended for this form’s responses.
• A Published WhatsApp Form in the correct workspace.
• Permission to send the form’s customer names, phone numbers, and answers to that Google account and spreadsheet. Check who can access the destination before continuing.

1

Open Save to Google Sheets

1. Open bitChat > WhatsApp form.
2. Find the intended form and check that its status is Published.
3. Open the form’s row menu and select Save to Google Sheets.

If the menu shows Open in Google Sheets, the form already has a destination. Open it and check the spreadsheet and worksheet before attempting a new setup. A Draft form does not show this export action.

2

Authorize your Google account

1. Select Login to Google and sign in with the account that can edit the destination spreadsheet.
2. Review the requested access and authorize it only if you are permitted to connect that account.
3. Back in bitbybit, check the email shown beside Connected to. Use Switch account if it is not the intended account.

3

Choose the spreadsheet and worksheet

1. Select Choose spreadsheet, then choose the destination in the Google file picker.
2. Under Worksheet, choose the tab where this form’s responses should be saved.
3. Check the selected spreadsheet and worksheet carefully before continuing.

4

Review the columns and save the destination

bitbybit builds the export columns automatically: customer number, customer name, the form’s input fields in form order, and the submission time. You do not map individual columns or add general customer-event fields in this setup.Select Continue to save the destination for this form and queue its existing responses for export. Later submissions use the saved destination as well.

5

Verify the connection

Check the destination before relying on it. A successful setup does not establish that every response has synchronized.

• Open the intended spreadsheet and worksheet. Compare existing rows with the form’s responses in bitChat.
• Check that the columns and answer values match the form.
• When an authorized new submission is available, confirm that it appears in the same worksheet. Use test data only if you have permission to submit and export it.

If responses are missing, confirm the correct form, account, spreadsheet, worksheet, and Google edit access first. Do not repeatedly save the destination or reconnect the account to force an export. Record the form ID, time, and exact error for support, without sharing credentials or unrelated customer data.