Stream data to a spreadsheet

How to automatically send form answers to spreadsheets

You can set up Tallyfy to automatically send the answers entered into your form fields to a spreadsheet (like Google Sheets or Excel Online). This is useful for gathering data in one place for reporting or connecting to other tools. You typically use a middleware tool (like Zapier, Make, or Power Automate) to make this connection.

Why send form data to spreadsheets?

• Collect data: Gather answers from many different runs of a process into one central sheet.
• Create reports: Use the spreadsheet data to build charts or reports.
• Keep records: Have a historical log of all form submissions.
• Connect systems: Use the spreadsheet as a bridge to send Tallyfy data to other business tools.
• Share data: Make collected information easily accessible to team members.

How to set it up (using middleware)

You can use different middleware tools to connect Tallyfy to your spreadsheet:

• Zapier: Generally easy to use with lots of pre-built connections.
• Microsoft Power Automate: Good choice if you use Microsoft 365 (Excel Online, SharePoint).
• Make.com (formerly Integromat): Offers powerful features for complex workflows.
• Custom Code: Developers can use Tallyfy webhooks and the API to build a direct connection.

Choosing a Tool

For simple connections, Zapier is fine. For more complex needs or higher volume, consider Make.com or Microsoft Power Automate. Using the Tallyfy API directly offers the most control but requires coding.

General setup steps

While the exact clicks vary by middleware tool, the basic process is:

1. In Tallyfy, set up a webhook on the template step that contains the form. Configure it to trigger when the task/form is completed.
2. In your middleware tool (Zapier, Make, etc.), create a new workflow that starts with a “Webhook” trigger, using the URL Tallyfy gives you.
3. Add an action step in your middleware workflow to connect to your spreadsheet app (Google Sheets, Excel Online).
4. Configure the action to “Add a new row” (or similar).
5. Match the data coming from the Tallyfy webhook (the form field answers) to the correct columns in your spreadsheet.
6. Test the workflow to make sure data appears correctly in your spreadsheet.

Video example (using Zapier)

This video shows the process using Zapier, but the main ideas apply to other middleware tools too:

Related articles

Analytics > CSV file structure

Tallyfy’s CSV export feature organizes process data into 45 columns spanning process details task information form fields and comments for comprehensive tracking and analysis.

Documents > Send data to document creation systems

The process enables automatic document creation by connecting Tallyfy form field data to document generation services through middleware tools like Zapier or Microsoft Power Automate for seamless workflow automation.

Analytics > How Tallyfy Analytics works

Tallyfy Analytics securely processes workflow data through event detection data extraction format conversion cloud storage and access provisioning to enable analysis in business intelligence tools like Power BI and Tableau.

Processes > Export process to CSV

A comprehensive CSV export feature allows downloading process data including tasks form responses and metadata for analysis reporting or backup in spreadsheet applications.