I Copy and Paste Between Apps All Day. How Do I Automate It?
You run a business and a significant chunk of your day is spent moving information between tools. A customer fills in a form, you copy their details into a…
You run a business and a significant chunk of your day is spent moving information between tools. A customer fills in a form, you copy their details into a spreadsheet. A payment comes in on Stripe, you paste the amount into a tracking document. Someone books a call, you manually add them to your email list. You have been doing this for months and it works, but it is slow, tedious, and occasionally you miss something. This is exactly the problem that automation tools like Zapier, Make.com, and Claude were built to solve.
Why You Are Still Doing This Manually
Most business owners know automation tools exist. The reason they have not set them up yet is usually one of three things: they tried once and got confused, they assumed it would take too long to set up, or they did not realise the specific thing they do manually is automatable.
The good news is that most manual copy-paste workflows between apps are automatable in under an hour with no code and no developer. Here is how to approach it.
Step 1: Write Down Exactly What You Do Manually
Before touching any tool, write down one specific manual workflow in this format:
“When [this happens], I go to [tool A], copy [this specific information], and paste it into [tool B].”
For example: “When someone fills in my Typeform contact form, I go to the Typeform responses, copy their name and email, and paste them into my Google Contacts and my Notion client database.”
This sentence is your automation specification. It contains everything you need.
Step 2: Check If Zapier Connects Your Specific Apps
Go to zapier.com and search for the two apps in your workflow. Zapier connects over seven thousand apps including Google Sheets, Notion, Typeform, Airtable, Stripe, Gmail, Slack, Trello, HubSpot, Mailchimp, Calendly, and almost every major business tool.
If both your apps are on Zapier, your automation is probably a few clicks away with no code at all:
- Create a free Zapier account
- Click Create Zap
- Choose your trigger app and the event that starts the workflow (e.g. Typeform: New Response)
- Connect your Zapier account to that app
- Choose your action app and what to do (e.g. Google Contacts: Create Contact)
- Map the fields: name goes to name, email goes to email
- Turn it on
Done. Zapier now watches the trigger and runs the action automatically every time.
Step 3: If One App Is Not on Zapier, Use a Script
If one of your apps is not in Zapier’s library, or if the connection you need is not available, this is where an AI-written script closes the gap.
Ask Claude, ChatGPT, or Gemini: “I want to automate the following task: when [describe the trigger event and which app it happens in], automatically [describe the action and which app it goes to]. What is the simplest way to set this up? Can you write a script that does this and tell me how to run it automatically?”
Your AI will either suggest a Zapier connection you missed or write a Python script that does exactly what you described. The script can be set to run automatically using GitHub Actions or Snapdock so it does not need your laptop to be open. → Snapdock
The Most Commonly Automatable Copy-Paste Tasks
These are the workflows most small business owners do manually and can automate in under an hour:
New contact from any form to Google Contacts, Notion, or Airtable. Payment received to Google Sheets row or Notion database entry. New booking to email notification and calendar event. Customer email to task in Trello or Asana. Invoice paid to client status update. New social media mention to Slack alert.
The One Thing to Remember
If you can describe your manual copy-paste workflow as “when X happens in tool A, copy Y and put it in tool B,” it is automatable. Start with Zapier by searching for your two apps. If both are there, you can set up the automation today with no code. If not, describe the workflow to your AI and ask it to write a script that does the same thing.
Want your automated scripts running without keeping your laptop open? → Snapdock
New here? These might help: The complete guide to running your app automatically. No developer required. → Why does my script stop when I close my laptop? →