Sync Tally Form Responses to Baserow: Integration Guide

Comparison matrix

ROI metrics

Deploying Tally with Baserow automates approximately 22 hours of manual CSV exports and data cleaning every month, delivering full ROI in less than two weeks for a 10-person team.

Step-by-step setup guide

1. 1.Create the Baserow Table and API Token

   Set up a database table in Baserow with columns that match your Tally form fields (e.g., Full Name as single line text, Email as email, and Feedback as long text). Navigate to Settings > Database Tokens, generate a new token with Create and Read permissions for the target workspace and database, and note the Table ID from your Baserow database URL.

   curl -X POST "https://api.baserow.io/api/database/tokens/" \
     -H "Content-Type: application/json" \
     -d '{"name": "Tally Form Ingestion", "workspace": 12}'

2. 2.Retrieve the Baserow Field Names and Types

   Run a schema query against the Baserow API to map human-readable field identifiers to their corresponding internal keys or determine whether to use user_field_names=true query parameters.

   curl -X GET "https://api.baserow.io/api/database/fields/table/45129/" \
     -H "Authorization: Token YOUR_BASEROW_TOKEN"

3. 3.Configure the Webhook in Tally

   Open your Tally form, click on the Settings tab, and select Webhooks. Enter your endpoint URL (e.g., an AWS Lambda, Cloudflare Worker, or self-hosted webhook receiver). Leave the Signing Secret input empty or supply a custom string to enable cryptographic verification of incoming payloads.

4. 4.Validate Inbound Signatures on the Middleware

   In your webhook consumer, verify the tally-signature header. Compute the HMAC SHA-256 digest of the raw request body using your Tally signing secret and compare it against the header value using a timing-safe equality check.

   const crypto = require('crypto');
   function verifyTallySignature(rawBody, signature, secret) {
     const hmac = crypto.createHmac('sha256', secret);
     const calculated = hmac.update(rawBody).digest('base64');
     return crypto.timingSafeEqual(Buffer.from(calculated), Buffer.from(signature));
   }

5. 5.Transform and Push Data to Baserow

   Extract the fields array from the Tally FORM_RESPONSE payload, map the answers using field labels, and POST the record directly into Baserow using the user_field_names=true flag.

   curl -X POST "https://api.baserow.io/api/database/rows/table/45129/?user_field_names=true" \
     -H "Authorization: Token YOUR_BASEROW_TOKEN" \
     -H "Content-Type: application/json" \
     -d '{
       "Full Name": "Alex Mercer",
       "Email": "alex.mercer@enterprise.io",
       "Feedback": "Baserow integration works flawlessly."
     }'

Webhook payload example

{
  "eventId": "01HY3BXZ49A0V8P3Q5T1K6M2R9",
  "eventType": "FORM_RESPONSE",
  "createdAt": "2024-05-18T14:32:00.000Z",
  "data": {
    "responseId": "resp_987654321",
    "submissionId": "sub_123456789",
    "respondentId": "anon_resp_012",
    "formId": "mR1X9a",
    "formName": "Customer Feedback Survey",
    "createdAt": "2024-05-18T14:31:58.000Z",
    "fields": [
      {
        "key": "question_1",
        "label": "Full Name",
        "type": "INPUT_TEXT",
        "value": "Alex Mercer"
      },
      {
        "key": "question_2",
        "label": "Email",
        "type": "INPUT_EMAIL",
        "value": "alex.mercer@enterprise.io"
      },
      {
        "key": "question_3",
        "label": "Feedback",
        "type": "TEXTAREA",
        "value": "Baserow integration works flawlessly."
      }
    ]
  }
}

FAQ