Getting data and events out

Sending analytics and answers to yourself or third parties.

Formsort can send three types of responder data to integrations - answers, uploads, and analytics events.

• Answers contain the full answers schema of the flow

• Uploads include any files, images, or signatures

• Analytics events capture the meta data of a responders journey through a flow

From the Integrations tab, you can configure where you were will send data, the shape of submission data, and the frequency with which data is sent.

For any changes in the Integrations tab to be reflected in your flow/variant, you must republish after changes are made.

Sending answers

BigQuery, Redshift, and Webhooks can be configured to receive answer payloads. At the submission frequency that you define, the entire answer payload will be sent to the integration.

Due to the distributed nature of our system, there are a couple of factors you should consider when setting up BigQuery, Redshift, and Webhooks integrations: 1. Ordering of answer submissions is not guaranteed. This can be particularly noticeable when you use a submission frequency of “Every Step”. For example, if steps are completed in quick succession, ordering of your submissions may not exactly match completion order. 2. While we guarantee at-least-once delivery of all answer submissions, regardless of frequency, we cannot guarantee only-once delivery. All integration targets should be designed with idempotency in mind. Receiving a duplicate answer submission should not adversely affect processing.

When does passed in data get sent?

Answers passed in via URL parameter or POST body will be included in all answer payloads regardless of the step order.

Sending data to a Google Spreadsheet

Spreadsheets are not databases, and have a slew of problems when you treat them as such, however, we recognize their usefulness, particularly when getting a new project up to speed.

Coming soon is a first-party integration with Google Sheets, for the time being you can run the google sheets webhook receiver to massage a webhook into a spreadsheet row.

Sending analytics events

Amplitude, Google Analytics, Google Tag Manager, and Segment can be configured to receive analytics events.

The analytics destinations can also receive answer payloads. You must opt-in to this when configuring them in the integrations editor by toggling "Send answers" on.

Receiving uploads

Amazon S3 and Google Cloud Storage can be configured to receive uploads, such as from file upload, image upload, or signature questions. The answer itself will contain the S3 or GCS URL of the uploaded asset.