Jotform Submissions to Google Sheets for Hospitality & Tourism

# Jotform Submissions to Google Sheets - Hospitality & Tourism

## Purpose
Use when you need a simple, shareable record of form submissions that non-technical team members can access and filter.

## When to Use
Automatically capture Jotform submissions in a Google Sheets spreadsheet for easy analysis, reporting, and team collaboration on form data.

## Instructions
1. Review the template below and familiarise yourself with the structure
2. Replace all [bracketed placeholders] with your hospitality & tourism business details
3. Customise the tone and formatting to match your brand
4. Save in your preferred tool (Zapier)

---

## Jotform Submissions to Google Sheets

### Overview
Automatically add a new row to a Google Sheets spreadsheet every time someone submits a Jotform, creating a living database of submissions that your team can filter, analyse, and collaborate on in real time.

### Prerequisites
- Jotform account (Free plan or above)
- Google account with Google Sheets access
- Zapier account (Free plan works for this automation)

### Setup Steps

**Step 1: Prepare your Google Sheet**
- Create a new Google Sheet and name it (e.g., "Website Enquiries - 2025")
- In Row 1, add column headers matching your Jotform fields:
  - A1: Submission Date
  - B1: Full Name
  - C1: Email
  - D1: Phone
  - E1: Company
  - F1: Enquiry Type
  - G1: Message
  - H1: Status (leave this for manual tracking, e.g., "New", "Contacted", "Closed")
- Format Row 1 as bold and freeze it (View > Freeze > 1 row)

**Step 2: Create a new Zap in Zapier**
Log in to Zapier and click "Create Zap". Name it "Jotform to Google Sheets".

**Step 3: Configure the Jotform trigger**
- App: Jotform
- Trigger event: "New Submission"
- Account: Connect your Jotform account
- Form: Select the specific form you want to track
- Test: Submit a test entry through your Jotform and verify Zapier retrieves it

**Step 4: Configure the Google Sheets action**
- App: Google Sheets
- Action event: "Create Spreadsheet Row"
- Account: Connect your Google account
- Spreadsheet: Select the spreadsheet you created in Step 1
- Worksheet: Select the correct sheet tab (usually "Sheet1")

**Step 5: Map fields**

| Jotform Field | Google Sheets Column | Notes |
|--------------|---------------------|-------|
| Submission Date | A: Submission Date | Use Jotform's timestamp |
| Full Name | B: Full Name | Or map First Name + Last Name separately |
| Email | C: Email | Primary contact field |
| Phone | D: Phone | Include as submitted |
| Company | E: Company | If applicable |
| Dropdown / Radio | F: Enquiry Type | Maps the selected option |
| Text Area | G: Message | Full message content |
| (leave blank) | H: Status | Will be filled manually by your team |

**Step 6: Add a timestamp formula (optional)**
In column I, add a formula to calculate days since submission:
=IF(A2<>"", TODAY()-DATEVALUE(TEXT(A2,"YYYY-MM-DD")), "")
This helps your team track response times.

**Step 7: Test the integration**
1. Submit a test entry through your Jotform
2. Wait 1-2 minutes for the Zap to trigger
3. Open your Google Sheet and verify the new row appears with correct data
4. Check that all columns are populated and formatted correctly
5. Submit a second test entry to confirm consistent behaviour

### Error Handling
- **Column mismatch:** If you add or remove columns in Google Sheets, update the Zapier field mapping to match
- **Special characters:** Jotform submissions with special characters (e.g., emojis, accented letters) will transfer as-is to Google Sheets
- **Sheet full:** Google Sheets supports up to 10 million cells. For high-volume forms, create a new sheet each quarter.
- **Permission errors:** Ensure the Google account connected to Zapier has edit access to the spreadsheet

### Maintenance
- Create a new sheet tab or spreadsheet at the start of each quarter or financial year for clean reporting
- Review column headers if you modify your Jotform fields
- Share the Google Sheet with relevant team members and set appropriate permissions (edit vs view)
- Set up Google Sheets email notifications for new rows if your team needs alerts beyond Zapier

---

**Complexity:** simple | **Setup time:** 5 minutes | **Tools:** Zapier

Note: This template has been tailored for hospitality & tourism businesses in Australia. Adjust terminology and compliance references to match your specific context.