Automations

How to automate data entry between two apps

The short answer

Pick the source of truth and a key both apps share, such as an email, map each field, and use create-or-update so nothing is entered twice. Run it beside manual entry for a week first.

4 min read

Which kind of setup do you need?

Do you edit these records in both apps?
Automation

Two-way sync: a different, harder job

You need a rule for which change wins and a guard against loops. Start one way, and add the other direction only if you truly must.

Does any field need judgement, like sorting free text?
Automation

A one-way automation with create-or-update

Fixed steps, matched on a shared key. Follow the steps below.

AI agent

An automation with one AI step

Keep the steps fixed and let AI handle only that field, such as sorting a message into billing, bug or question.

Read: AI agent vs automation: which one you need

Write the field map first

A field map is a two-column list, written before you build. It shows you every gap. Here, Facebook Lead Ads into a CRM:

From the formTo the CRMNote
full_nameFirst name, Last nameSplit on the first space
emailEmailThe key; lower-case it
phone_numberPhoneKeep the + and country code
Form nameLead sourceFixed text per form
created_timeCreate dateConvert from UTC
(none)Lifecycle stageSet to Lead

How to automate data entry between apps, step by step

  1. Step 1: Find the trigger in the source app

    The event that means "new record": a form submitted, an order placed, a row added. In viaSocket's catalog Facebook Lead Ads has "New Lead Submitted".

  2. Step 2: Use create-or-update in the destination

    HubSpot has "Create or Update Contact". Where an app has only "Create", add a find step first and stop if the record exists.

    Watch out. Some triggers never skip repeats, so the same person can arrive twice. Create-or-update on a key is the fix in every tool.

    Do this step in 50agents

    Set up an automation: every new Facebook lead is added to HubSpot as a contact, or updated if the email already exists

    Build it

    Captain reads one real lead from your form to see the fields, maps them, and tests the steps on it. Writing to your own CRM runs without asking.

  3. Step 3: Clean values on the way

    Trim spaces, lower-case emails, fix date formats, split names. Most "the automation broke" reports are a format the second app rejected.

  4. Step 4: Test with 10 to 20 real records

    Include awkward ones: no phone, a name with three parts, an email in capitals.

  5. Step 5: Run it beside manual entry, then stop typing

    Compare the two for a week. When they match, switch off the manual step.

  6. Step 6: Backfill old records separately

    Import the history once, by file, and let the automation handle new records only.

What can go wrong

  • Ping-pong between two apps

    App A updates B, which updates A, forever. Run one direction only, or skip changes made by the automation itself.

  • A field the other app does not have

    Data drops without a sound. List every source field in the map, and put the ones with no home in a notes field.

  • Dates in the wrong format

    03/04 is March in one app and April in another. Convert to an unambiguous format on the way.

  • A backfill hits rate limits

    Pushing 5,000 old records through an automation trips the destination's limits. Import history by file instead.

Questions people ask

Can I sync two apps both ways?

You can, but it is a different job: you need a rule for which change wins, and a guard against loops. Start one way, and add the other direction only if you truly edit in both.

How do I stop duplicate records?

Match on a key both apps share, such as email or order number, and use create-or-update. Where the destination has only create, find first and skip if it exists.

What if the data needs judgement, like sorting free text?

Add an AI step for that one field, for example "sort this message into billing, bug or question", and keep the rest of the steps fixed.

What if a field exists in one app but not the other?

Decide on the field map before you build. Either create the field in the destination app, put the value in a notes field, or leave it out on purpose. A gap you chose beats one you find later.

How do I move the records I already have?

Import the history once, by file, and let the automation handle new records only. Running a big backfill through the automation can hit the apps' rate limits.

Why did my automation stop adding records?

Usually a value the second app rejected: a date in the wrong format, a phone without a country code, an email in capitals. Clean values on the way, and test with awkward records.

Read next

Or let Captain build it

One sentence to Captain. Free to start.

Build it with Captain
How to automate data entry between two appsBuild it