Get WhatsApp Web contact data into a Google Sheet

Want to save your WhatsApp contacts into your sales or personal tracking systems?

‍

This playbook will save you some copy/pasting by scraping a WhatsApp Web contact getting it's profile information into a Google Sheet.

‍

To run this, go to an opened WhatsApp Web conversation and run the playbook.

‍

It'll ask you to input a Google Sheet. You can select an already created Google Sheet, or create a new one with the "Create a new Google Sheet with Name" command.

‍

The output data is different depending on the type of profile:

• Known and saved contact
  Gets the "phone", "about", "label", "name", and "image" fields.‍

• Business contact
  Gets the "business_account_phone", "business_account_name", "label", "about", and "image" fields.

• Unknown contact
  Gets the "unsaved_name", "unsaved_phone", "label" and "image" fields.

‍

On the Google Sheet, phone numbers might appear as "ERROR" fields. That happens they contain a "+" sign and are formatted as formulas. You can remove the symbol or add a space to get the text.

‍

Locate additional integration choices for WhatsApp automations, Scraper automations, Google Sheets automations, or customize the playbook to better align with your personalized workflow.

‍

Also, seek out additional integration options for integrating WhatsApp and Google Sheets.

‍

Learn more about the awesome sales and prospecting automation and personal productivity automation available.

‍