To ensure data from your Swipepages form correctly populates your Google Sheet, you need to define the fields (column headers) in the first row of your sheet. These headers will then appear in Swipepages' field mapping settings, allowing you to connect your form fields to the corresponding sheet columns.
Open Your Google Sheet: Navigate to the Google Sheet you intend to connect with your Swipepages form.
Identify the First Row: Locate Row 1, which is the very top row of the spreadsheet grid, just below the column letters (A, B, C, etc.).
Enter Field Names in Row 1:
Click into cell A1. Type the name of the first field you want to capture (e.g., "Name").
Click into cell B1. Type the name of the second field (e.g., "Email").
Click into cell C1. Type the name of the third field (e.g., "Phone").
Continue this process for all the data fields you want to receive from your Swipepages form, adding each field name into the next available cell in Row 1.
Crucial Point: These field names must be entered in Row 1. This is how Swipepages identifies the available columns for mapping.
Example: See the image below. The headers "Name", "Email", and "Phone" have been added to cells A1, B1, and C1, respectively.
Map Fields in Swipepages:
Go back to your Swipepages form settings, where you configure the Google Sheets integration.
When you reach the field mapping step, you should now see the field names you added to Row 1 of your Google Sheet listed as available destination fields.
Map your Swipepages form fields to the corresponding Google Sheet field names you just created.
Save and Test: Save your integration settings in Swipepages and submit a test entry through your form to confirm the data appears correctly in the designated columns in your Google Sheet.