XForms home

Products

3


XForms Mobile

Mobile forms for field data collection

Mobile App

Form Designer

Dashboard

APIs & Integrations

Use Cases

Pricing

Start free trial →



CX2

Commissioning completions, rebuilt · Coming 2027

Mobile app

Completion

Add-ons

Punchlist & reports

Setup

Hand-off

Compare

Early access

Request early access →



XDocs

AI documents, from proposal to final report

Field app

AI writing

Report builder

Workload & review

How it works

Solutions

Compare

Join the waitlist →

NOT SURE WHERE TO START?

Compare the three products side by side

See which one fits your team, or talk to us and we’ll point you to the right tool.

Compare products →

Talk to us →

Resources

3

LEARN

Blog

Product news, how-tos and field stories

Customer stories

How field teams use XForms

Example use cases

Inspections, audits, sampling and more

GET HELP

Support center

Guides, FAQs and login links

XForms Mobile support

XForms Cx support

XDocs support

Contact us

WHAT’S NEW

Release notes

Every update to XForms Mobile and XForms Cx, newest first

LATEST FROM THE BLOG

Illustration of a tracked route with location pins and completed checklist items

Tracking waste from cradle to grave using smartphones + AI

All posts →

About

Log in

3

LOG IN TO

XForms Mobile

XForms Cx

XDocs

Contact us
XForms
  • Products
    • XForms Mobile
    • CX2
    • XDocs
  • Resources
    • Blog
    • Customer stories
    • Support center
  • About
  • Contact
  • Log in
    • XForms Mobile login
    • XForms Cx login
    • XDocs login
Blog/XForms Mobile/How to integrate table row data from a mobile form into Google Sheets

How to integrate table row data from a mobile form into Google Sheets

XForms Mobile

An integration between XForms Mobile and GSheets gets you a nice field capture tool that automatically inserts captured table data right into Google Sheets.

XF

XForms team

Aug 21, 2022

How to integrate table row data from a mobile form into Google Sheets

ON THIS PAGE

No headings found in this post.

    SHARE

    Not all generic form software support table grids inside of field forms

    Believe it or not, XForms is one of the very few generic form software tools in the market today that lets you build out customizable table grids that your field folks can fill out in the field on tablets, phones, and laptops.  So when shopping for a customizable software tool for your field forms, if your existing paper forms have a lot of tables in them, be sure to check if that software tool is capable of producing tables.

    Why is this important?  Check out the illustration below comparing a tool that has a table feature against one that doesn’t.

    Comparison of a form tool with a table grid feature versus one without

     Step 1 – Build your form and add your table to it

    In the XForms Designer, build your form, and add a table to it by clicking on the “+ Add Field” button and selecting “Table”.

    Animation of adding a table field to a form in the XForms Designer

    You can customize tables fairly easily in the XForms Designer.

    The first step is to add a column by clicking on the “+ Add Column button.  Pick the field type from the list (e.g., checkbox, text, number, multichoice, etc).  Each field type will have some unique options available to it.

    Next determine if the field user should be able to add rows or not.  That’s what the “Can Add Rows” on/off switch is for.

    You can also add rows as needed.  These are usually added whenever you have specific text that needs to be displayed on rows when a form pre-loads.

    You can also add a footer, which is generally used if you need to count the number of rows, add the numbers in a column, determine the average of a numerical column, etc.  If you need this, flip the “Show Footer” switch to on.

    XForms Designer table editor for adding and configuring columns

    XForms Designer table editor with column settings and Show Footer option

     Step 2 – Create your Google Sheet

    Most folks probably already have a target sheet in Google Sheets ready to go.  If not, just create it.  Make sure you match up the columns in your GSheet to the columns in yoour XForms table.  They should match up from left to right.

    Step 3 – Create an integration between XForms and Google Sheets using a tool like Zapier, Integrately, Make.com, etc

    This part is a bit more challenging, but we are hard at work building out a Make.com integrator applet to make it easy.  For now, you can outsource this to a dev shop, use your own IT folks, or let us do it for you.  It’s basically a matter of connecting the dots between the XForms open APIs and Google Sheet’s APIs.

    Make.com scenario connecting XForms table row data to Google Sheets

    The benefits of these kinds of integrations

    XForms Mobile is a super easy to use mobile app that can run on most any sort of device, including iOS and Android phones.  It even runs on shitty Kindle Fire tablets (kind of sluggish, but those devices are practically disposable).  It also runs in offline mode.  So using XForms Mobile for the data capture  side of things in the field, in a wide variety of scenarios, is a natural fit.

    Google Sheets is a very common tool that most anyone understands how to use.  It is often used a fnal repository for data, with sharing capabilities built-in.

    An integration between the two gets you a nice field capture tool that automatically inserts captured table data right into Google Sheets, for further analysis, processing, and sharing.

    And you can do this with any other spreadsheet-like tool, including AirTable, Smartsheet, and even Excel 365 (the online version).

    Want to learn more?

    Click/tap the button below.

    Contact Us

    TRY XFORMS

    Wanna give it a try, risk-free?

    Build a form, capture a record offline and see it land in your dashboard.

    Start free trial
    Talk to us

    XF

    WRITTEN BY

    XForms team

     

    Keep reading

    ← Back to all posts

    Tracking waste from cradle to grave using smartphones + AI

    XForms Mobile

    Sep 5, 2025

    Tracking waste from cradle to grave using smartphones + AI

    How do you ensure that the decarbonization end-product you are paying top dollar for originated from actual waste, and not virgin material?

    Read more →

    Photos in table rows

    XForms Mobile

    Mar 2, 2025

    Photos in table rows

    Now you can take a photo within a table grid row, enabling you to take pictures of something specific and relevant to the information in that row of your table.

    Read more →

    Photo metadata improvements

    XForms Mobile

    Jan 6, 2025

    Photo metadata improvements

    Photo metadata is now captured at the photo level instead of at the form level. This enables viewing of the geolocation of each photo taken, which could differ for each photo captured on the same form.

    Read more →

    NEWSLETTER

    Get new posts in your inbox

    Product updates, field-tested how-tos and customer stories from XForms Mobile, Cx and XDocs.

    New blog newsletter signup

    One email when we publish. Unsubscribe anytime. or request a demo →

    XForms logo

    Field data, commissioning completions and AI documents for teams who work on site. XForms LLC — Raleigh, NC & Bellevue, WA.

    

    XFORMS MOBILE

    Overview

    Mobile App

    Form Designer

    Dashboard

    Pricing

    Support

    Help center

    

    CX2

    Overview

    Mobile app

    Completion

    Add-ons

    Punchlist & reports

    Setup

    Compare

    Early access

    Support

    

    XDOCS

    Overview

    Field app

    How it works

    Solutions

    Compare

    Support

    COMPANY

    About

    Blog

    Support center

    Help center

    Contact

    Privacy Policy

    Terms of Service

    © 2026 XForms LLC. All rights reserved.

    Privacy Policy · Terms of Service