• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

3 min read

How to automatically add Seamless.AI contacts to a Google Sheet

By Will Harris · May 16, 2023
Hero image for a blog post about importing Seamless.AI contacts to a Google Sheet.

If you've used Seamless.AI, you know how much time it saves while collecting contact information for sales outreach. What used to take hours of scouring websites and LinkedIn for an email address or a phone number now only takes a few minutes.

Moving that contact information to different platforms, though, can be messy. Seamless.AI has a handful of direct integrations with tools like Salesforce and Hubspot that make it easy to add contacts to those platforms. But if you're using a different CRM—or if you like keeping contact info in a spreadsheet—you have to move that data manually, which is slow, error-prone, and doesn't scale very well.

So, why not automate it? With Zapier, you can create a Zap—our word for our automated workflows—that takes all of your new contacts from Seamless.AI and adds them to the spreadsheet or CRM of your choice, making it incredibly easy to keep your prospect info up to date.

New to Zapier? It's workflow automation software that lets you focus on what matters. Combine user interfaces, data tables, and logic with thousands of apps to build and automate anything you can imagine. Sign up for free.

Add new Seamless.AI contacts to a Google Sheet

In this blog post, we'll create a Zap that automatically adds Seamless.AI contacts to a Google Sheet, but you can easily replicate this formula with a different platform. If you use a CRM like LeadConnector or Close or a database tool like Airtable, you can use the same steps to move your contacts to those platforms as well.

If you want to start with a template, click the Zap template below, and you'll be taken to the Zap editor. If you don't have one, you'll need to create a Zapier account. Then, follow the directions below to set up your Zap.

Create Google Sheets Rows for New Seamless.AI Contacts

Create Google Sheets Rows for New Seamless.AI Contacts
  • Seamless AI logo
  • Google Sheets logo
Seamless AI + Google Sheets

Set up your Seamless.AI trigger

The first step is setting up your trigger, or the event that starts your Zap. Pick Seamless.AI as your trigger app and New Contact as your event. Click Continue.

A screenshot of the setup for a trigger step featuring Seamless.AI in the Zapier editor.

Next, it's time to sync your Seamless.AI account. Click Choose an account… and either select an account from the dropdown menu (if you've connected Seamless.AI before) or click + Connect a new account. Then click Continue.

Now, it's time to customize your trigger step by setting parameters around which contacts you'd like to include. You can choose only to add contacts based on which lists they belong to in Seamless.AI or by the type of email address associated with each contact (personal, business, etc.).

If you want to add every contact to the spreadsheet, you can leave these fields empty.

A screenshot of the setup for a trigger step using Seamless.AI in the Zapier editor.

Once you're done customizing your step, click Continue.

Next, it's time to test your trigger. Zapier will find a recently added contact in Seamless.AI, and use it to set up the rest of your Zap. If you haven't added any contacts yet, make sure to do so. Otherwise, Zapier won't have any sample data to run a test with.

Click Test trigger. Once you run a successful test, click Continue.

A screenshot of a successful trigger step test in the Zapier editor.

Set up your Google Sheets action

Now it's time to set up your action step—the event that occurs once your Zap is triggered. Select Google Sheets as your app and Create Spreadsheet Row as your event. Click Continue.

Screenshot of a Google Sheets action step in the Zapier editor.

Like your trigger step, you'll be asked to connect your Google account to Zapier. Click Choose an account… and either select an account from the dropdown menu or click + Connect a new account.

Click Continue.

Now customize your action step by telling Zapier which Google Sheet to add your contacts to and what information to put in which column.

First, pick the spreadsheet and the specific worksheet to which you want to add your leads. Then, pull contact info from Seamless.AI and add it to specific fields in your Google Sheet by clicking in the appropriate fields and selecting the data from the Insert Data dropdown.

A screenshot of the setup for an action step adding Seamless.AI contacts to Google Sheets.

When you're done customizing these fields, click Continue.

Click Test action to have Zapier create a new spreadsheet row based on how you customized your fields.

Once your test is complete, check your Google Sheet to make sure everything looks correct.

A screenshot of a successful contact transferred from Seamless.AI to Google Sheets.

If everything looks good, you're ready to turn on your Zap. If some information ends up in the wrong columns, go back and tweak things until everything looks right.

Keep track of your lead data

Seamless.AI is a big time-saver for sales development teams who don't want to spend all day searching every corner of the internet for contact information. Getting that contact information out of Seamless.AI and where you need it to go, though, can be tricky.

By using Zapier to add automation into the mix, you can efficiently and reliably move your contact data from one platform to the next without having to download a single CSV file—giving your reps even more time to spend personalizing outreach messages, following up with leads, and closing deals.

Related content:

  • 3 ways to automate Seamless.AI

  • How to enrich lead info from sales forms with OpenAI and Zapier

  • How to score and analyze leads with OpenAI

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'