How to Send Form Submissions to Google Sheets

Set up FormsList with Google Sheets integration

Create a FormsList account and add a new form. In the integrations section of your form settings, connect your Google account and select the spreadsheet where you want submissions to appear. FormsList creates a new row for every submission automatically.

Create your form and map fields to columns

Build your HTML form with input names that match the columns you want in your spreadsheet. Each form field name becomes a column header in Google Sheets. FormsList maps them automatically: name goes to the Name column, email to the Email column, and so on.

<form action="https://formslist.com/f/YOUR_FORM_HASH" method="POST">
  <label for="name">Name</label>
  <input type="text" id="name" name="name" required />

  <label for="email">Email</label>
  <input type="email" id="email" name="email" required />

  <label for="company">Company</label>
  <input type="text" id="company" name="company" />

  <label for="role">Role</label>
  <select id="role" name="role">
    <option value="">Select...</option>
    <option value="developer">Developer</option>
    <option value="designer">Designer</option>
    <option value="manager">Manager</option>
    <option value="other">Other</option>
  </select>

  <label for="message">Message</label>
  <textarea id="message" name="message" rows="4" required></textarea>

  <button type="submit">Submit</button>
</form>

<!-- Each field name (name, email, company, role, message)
     becomes a column in your Google Sheet automatically. -->

View your live spreadsheet and build reports

Open your Google Sheet to see submissions appear in real time. Each new submission adds a row with a timestamp and all the field values. Use Google Sheets features like filters, charts, and pivot tables to analyze your data. Share the sheet with your team so everyone can see incoming submissions without needing a FormsList account.