Integrating Tally with Notion for Content Intake

Comparison matrix

ROI metrics

Automating content ingestion saves 24 engineering and editorial hours per month across a 10-person team, yielding a complete payback in under 3 weeks.

Step-by-step setup guide

1. 1.Create a Notion Database and Internal Integration

   Navigate to Notion Developers (developers.notion.com), click 'New integration', name it 'Tally Intake Sync', and select your workspace. Copy the generated Internal Integration Secret. In your Notion workspace, create a database with columns: 'Title' (title), 'Author' (rich_text), 'Content Type' (select), and 'Summary' (rich_text). Share this database with the integration via the page settings.

   curl -X GET 'https://api.notion.com/v1/databases/NOTION_DATABASE_ID' \
     -H 'Authorization: Bearer secret_live_xxx' \
     -H 'Notion-Version: 2022-06-28'

2. 2.Build the Content Intake Form in Tally

   Open Tally, build a new form with fields matching your Notion schema: 'Article Title' (Short answer), 'Author Name' (Short answer), 'Content Type' (Dropdown), and 'Article Abstract' (Long answer). Note each field's unique identifier in the form settings for JSON mapping.

3. 3.Configure Native Notion Integration or Custom Webhook

   In Tally form settings, go to 'Integrations' -> 'Notion' to use the 1-click OAuth sync, or select 'Webhooks' to point to an intermediate microservice or AWS Lambda URL if field transformations or HMAC verification are required. Enter your endpoint URL and set the signing secret.

4. 4.Validate Payload and Map Fields to Notion API

   When using a webhook handler, parse Tally's FORM_RESPONSE payload, verify the 'tally-signature' header using HMAC-SHA256, and dispatch a POST request to Notion's pages endpoint to create the content record.

   curl -X POST 'https://api.notion.com/v1/pages' \
     -H 'Authorization: Bearer secret_live_xxx' \
     -H 'Content-Type: application/json' \
     -H 'Notion-Version: 2022-06-28' \
     -d '{
       "parent": { "database_id": "b94d12c8-99e2-4521-8888-abcdef123456" },
       "properties": {
         "Title": { "title": [{ "text": { "content": "Scaling Edge Networks" } }] },
         "Author": { "rich_text": [{ "text": { "content": "Alex Rivera" } }] },
         "Content Type": { "select": { "name": "Technical Guide" } }
       }
     }'

5. 5.Test Submission and Handle Rate Limits

   Submit a test response through the published Tally form. Verify that a new entry appears instantly in your Notion database. Implement an exponential backoff retry policy (HTTP 429 handler) in your proxy if batching more than 3 submissions per second into Notion.

Webhook payload example

{
  "eventId": "d6a2f841-5c3b-48d6-9507-6bcf4bf78d65",
  "eventType": "FORM_RESPONSE",
  "createdAt": "2024-03-29T14:32:00.000Z",
  "data": {
    "responseId": "resp_9921bc1e0",
    "formId": "3yYdpV",
    "formName": "Content Intake Brief",
    "fields": [
      {
        "key": "question_article_title",
        "label": "Article Title",
        "type": "INPUT_TEXT",
        "value": "Optimizing DynamoDB for High-Throughput Ingestion"
      },
      {
        "key": "question_author_name",
        "label": "Author Name",
        "type": "INPUT_TEXT",
        "value": "Jordan Hayes"
      },
      {
        "key": "question_content_type",
        "label": "Content Type",
        "type": "DROPDOWN",
        "value": "Architecture Deep Dive"
      },
      {
        "key": "question_summary",
        "label": "Summary",
        "type": "TEXTAREA",
        "value": "A step-by-step review of partition keys and write sharding techniques."
      }
    ]
  }
}

FAQ