Bi-directional data sync

Keep Google Sheets synced with your post-production database

Editors work in Avid while producers track deliverables, budgets, and vendor notes in Google Sheets. Developing Tank connects those sheets to project data so updates stay in sync across both places.

ShotSheetSync
VFX_018ANeeds reviewSynced
VFX_021In progressSynced
VFX_034BRememberedSynced
One source of truth: database + Sheets stay aligned automatically.

Manual updates vs. database-backed sync

Without Google Sheets Sync

  • Upload sequence to populate trackers
  • Editor recuts the sequence
  • Someone manually updates the sheet
  • Vendors and producers get outdated data
  • Version confusion across teams
  • Repeated manual data entry

Result: Confusion, wasted time, outdated information.

With Developing Tank

  • Connect your Google Sheet once
  • Database and sheet stay in sync automatically
  • Producers edit sheets; changes flow back
  • Vendors always see current data
  • Updates sync between the database and sheet
  • One source of truth across all systems

Result: Less duplicate entry and fewer stale sheets.

Producers and post supervisors

Keep tracking sheets current without duplicate entry. New deliverables, budget changes, and vendor updates sync from project data.

VFX supervisors

Share current shot status with vendors through the sheet your team already uses.

Assistant editors

Upload your bin or EDL once. Producers can review updates without asking for another manual sheet pass.

Inputs

VFX database + Google Sheet (read + write access)

Process

Bi-directional sync, update handling, field mapping

Outputs

Database and sheet updates from one connected workflow

Bi-directional architecture

Two systems, one source of truth

Connect your Developing Tank project to a Google Sheet. VFX shots detected in the database appear in Sheets, and producer edits can flow back to the database.

Use the database as the source of truth while giving producers a spreadsheet view they already understand.

  • VFX shots and timecodes sync from the database
  • ADR notes, continuity, and editorial changes can update shared sheets
  • Music cue sheets and stock footage tracking stay current
  • Producers can edit sheets; changes reflect back in database
  • Works across multiple sheets and tabs in one file
Fewer mismatchesEliminate spreadsheet drift and version confusion.
Faster decisionsProducers and vendors review current data immediately.
Less adminStop retyping updates across systems.

VFX tracking

Shot status, timecodes, descriptions, and vendor notes all sync automatically as your project evolves.

ADR & dialogue

ADR notes created in Developing Tank sync to your producer's sheet for coordination and tracking.

Continuity reports

Continuity data syncs to sheets where producers can view, annotate, and share with editorial and vendors.

Music & cue sheets

Music cue sheets and stock footage tracking stay in sync across database and sheets without manual updates.

Sync capabilities

Integration between the database and Google Sheets

Bi-directional sync

Database changes flow to Sheets. Producer edits can flow back to the database, so this is not a one-way export.

Real-time updates

Changes sync during normal use, not through daily exports or manual copy-paste.

Custom field mapping

Define which fields sync between systems. Map database fields to the columns your sheet already uses.

Multi-sheet support

Set up syncing across multiple sheets and tabs in the same Google Sheets file so sensitive data stays on private sheets.

Frequently asked questions

Is this bi-directional, or a one-way export?

It is bi-directional for supported fields. Database changes flow to Sheets, and supported Sheet edits flow back to the database.

How often does it sync?

Updates sync during normal use. Exact timing can vary by sheet size, permissions, and Google API response time.

Can I sync multiple sheets at once?

Yes. One project can sync to multiple sheets and tabs. This is useful for keeping sensitive data on private tabs while sharing a public summary with vendors.

What happens if I edit the sheet manually and the database changes at the same time?

The database is the source of truth. If both systems change simultaneously, the database update wins. We recommend producers make changes in Sheets while editors work in Developing Tank.

Which database tables can I sync with Sheets?

VFX tracking, ADR tracking, scene data, continuity reports, and marker logs. Each is configured separately, so you only sync what you need.

Do the sheets need to be public?

No, you can keep your sheets private and invite only.

How it works

Sync the sheet your team already uses

Producers don’t need a new UI to get value from your database. They keep using Google Sheets while Developing Tank keeps the underlying data consistent across uploads, recuts, and handoffs.

That means VFX tracking, paperwork, and notes can stay in the database while remaining visible and editable in a format the rest of the team already understands.

Get started

Connect your database to Google Sheets