Loading

Google Contacts + Google Sheets

Create Google Contacts from new Google Sheets rows

Using Google Forms or Google Spreadsheets to collect and store contact data? This Google Sheets - Google Contacts integration will automatically create new contacts in Google Contacts when a new row is added to your spreadsheet.

Using Google Forms or Google Spreadsheets to collect and store contact data? This Google Sheets - Google Contacts integration will automatically create new contacts in Google Contacts when a new row is added to your spreadsheet.

  1. When this happens...
    Google SheetsGoogle Sheets
    New Spreadsheet Row

    Triggered when a new row is added to the bottom of a spreadsheet.

    TriggerInstant
  2. automatically do this!
    Google ContactsGoogle Contacts
    Create Contact

    Triggers when a contact is created or updated.

    ActionWrite
Try this template
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    Trigger
    Scheduled
    Try It
    • No Team Drive

      If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    • Trigger Column

      Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

    Trigger
    Instant
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

    • Column NameRequired

    • Index

      The column position (zero-based) to insert. If not set, append to the right by default.

    Action
    Write
    • No Team Drive

      If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Instant
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    • Trigger Column

      Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

    Action
    Write
google-contacts logo
google-contacts logo

About Google Contacts

Google Contacts, the address book built into Gmail, lets you keep track of all your contacts, see when you last interacted with them, and more.
Learn more

Related categories

  • Contact Management
  • Google

Similar apps

Microsoft Office 365 integrations

Microsoft Office 365

Email, Microsoft
Act! 365 integrations

Act! 365

Contact Management
Zoho Mail integrations

Zoho Mail

Email, Zoho
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

Similar apps

Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
Quip integrations

Quip

Documents

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.