MARKETING

Pull completed translations from Drive back into Coda and flag ready to publish

Detects a finished translation file dropped in the localization return folder, parses the locale and translated copy, writes it back to the matching Coda row.

CategoryMarketing
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew completed translation file in Drive return folderGoogle DriveGoogle Drive
  • ActionRead file and parse locale, row ID, translated copyGoogle DriveGoogle Drive
  • LogicMatch to Coda row and confirm locale not yet filled
  • ActionWrite translation into locale column on Coda rowCodaCoda
  • OutputSet locale status to Ready to PublishCodaCoda

What it does

Closes the return leg of the localization loop. When a translator drops a completed file into the return folder, this reads the locale and translated text, matches it to the original Coda copy row, writes the translation into the correct locale column, and marks that locale Ready to Publish so the publish queue picks it up.

When to use it

Use it when translations come back as files but someone still hand-copies them into your Coda source of truth and manually toggles status. This eliminates the transcription step and the stale-status problem.

How it works

  1. 1A new file lands in the Google Drive return folder and the trigger fires.
  2. 2The flow reads the file and parses the locale code, the source row ID, and the translated copy.
  3. 3A filter confirms the row exists in Coda and the locale column is still empty or in progress.
  4. 4It writes the translated string into that locale's column on the matching Coda row.
  5. 5It sets the locale status to "Ready to Publish" and timestamps the return.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Google DriveDocs, sheets, slides, files.
  2. 2
    Connect CodaDocs, packs, automations.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.