Google Sheets integration
Sync Mokaform submissions to Google Sheets rows for reporting, operations, exports, and spreadsheet-based workflows.
Use the Google Sheets integration when your team wants submissions in a spreadsheet for reporting, sorting, filtering, or lightweight operations.
Before you connect
- Create or choose the Google account that should own the spreadsheet connection.
- Decide whether Mokaform should write to an existing spreadsheet or a new one.
- Give important questions stable names before mapping.
- Prefer structured question types for values you want to filter or chart later.
Connect Google Sheets
Open the questionnaire and go to the integrations area.
Choose Google Sheets.
Connect or select the Google account.
Choose the spreadsheet destination.
Map each Mokaform answer to the spreadsheet column where it should be written.
Submit a test response and confirm a new row appears.
Field mapping
| Mokaform value | Google Sheets column type |
|---|---|
| Short text, Long text, Email, Phone, Website | Text |
| Number, Rating, Opinion scale, NPS | Number |
| Date, Time | Date/time or text, depending on your sheet formatting |
| Multiple choice, Dropdown, Yes/No | Text |
| Checkbox or multi-select answers | Text list |
| File upload or Signature | File URL or attachment reference when available |
| Submission metadata | Text, date, or number column depending on the field |
Practical tips
- Put a header row in the spreadsheet and keep column names clear.
- Do not delete or rename mapped columns without updating the integration.
- Use separate sheets for separate forms unless the forms have the same structure.
- Protect formula columns so incoming rows do not overwrite calculations.