Simplify your workflow and enhance efficiency by effortlessly syncing your Google Sheets data directly into Thryv®. By combining Thryv with Google Sheets, you are able to synchronize client, product, and appointment details and eliminate manual entry. This also eliminates the need for downloading and uploading multiple spreadsheets!

What is Google Sheets? Google Sheets is a cloud-based application offering the ability for you to create, edit, format and collaborate in real time on spreadsheets in your Google account.

This app integration is free in the Thryv App Market. You will need to sign in or create a Google Sheets account prior to installation. Google Sheets offers multiple packages you can choose from, both free and paid. Visit the Google Sheets website to see what option best suits your business.

Here is a breakdown of what data will sync between Google Sheets and Thryv. 

Prior To Installation

Clients

You will be able to manually map the columns from your Sheet to the CRM fields in Thryv, but for best results, you'll need to make sure your Sheet is formatted correctly. Click Here for our formatting guide for clients

Note: The app can only add information and not remove it. If a cell is blank, it will not remove information from that field. In addition, the app can not remove Tags from a customer, it can only add them.

Products

Importing products into Thryv Business Center™ will only create new products. It will not update an existing product, but instead create a duplicate. Ensure any existing products are removed from your sheet before import or they will be duplicated. Also, the app does not update existing products. If a product only needs to be updated it still needs to be edited directly in Thryv Business Center.

In order to import, you must have at least one Product already in your Thryv Business Center with all of the fields you will be using filled out. This example product can be deleted after the import. Click Here for a guide to adding a product.

To Import Products, the required fields in the spreadsheet are:

• Product Name
• Currency
• Price

Additionally, you can also add:

• Tax name
• Tax rate
• Description
• Image URL

Note: In order to import taxes, that tax must already be created in Thryv Business Center. Click Here for a guide to creating taxes

Appointments

Importing appointments into Thryv Business Center will only create new appointments. It will not update an existing appointment, but instead create a duplicate. Certain fields are required on your Google sheet in order for the import to function correctly. If a field is missing or invalid, the line will not sync to Thryv Business Center.

• Appointment Name
• Start Time
• Time Zone
• Location (in the form of valid address)
• Client email
• First Name
• Last Name
• Phone

Time Zone Format

It is critically important that your time zone is formatted properly or else your appointments won't sync. The time zone column must be worded and formatted to exactly match the table below. Pay careful attention to items like backslashes and underscores.

Install

To begin the installation, first locate Google Sheets in the Marketplace.

Click on Install in the top right corner

Next, you will need to grant Google Sheets permission to access your Business Center account. Check the box and click on Submit 

Sign into your Google account. Make sure it is the same Google account that has permission to access the Sheet you want to sync

Allow permissions to Integry to access your Google account

Then you will be brought to the app screen where you can set up the sync.

Import Clients

To start importing clients, click on Setup and Run under Google Sheets to Thryv Clients One-time sync.

In the next screen that appears, paste the link to your Google sheet, then click on Next

To grab the link to your Google sheet, navigate to the Sheet. Click on Share in the top right corner.

Then, in the pop-up that appears, click on Copy Link. The link will automatically be copied to your device clipboard. Then navigate back to the app and paste the URL in the field provided.

Next, select your worksheet. Use the drop-down, and select your worksheet.

Once your URL is entered and your worksheet is selected, click on Next

Next, map your columns to fields in your Business Center CRM by using the fields provided. Your Thryv fields will appear, enter the name of a column on your Google Sheet to map to that column.

Once you have mapped the desired fields, click on Next

You will reach a confirmation screen. Click on Save to continue.

The sync will run right away, you will see a confirmation of the time completed. If you update the Sheet and need to run the sync again, return here, click Setup and Run, and complete these steps again.

Import Products

To start importing products, click on Setup and Run under Google Sheets to Thryv Products One-time sync.

In the next screen that appears, paste the link to your Google sheet, then click on Next

To grab the link to your Google sheet, navigate to the Sheet. Click on Share in the top right corner.

Then, in the pop-up that appears, click on Copy Link. The link will automatically be copied to your device clipboard. Then navigate back to the app and paste the URL in the field provided.

Next, select your worksheet. Use the drop-down, and select your worksheet.

Once your URL is entered and your worksheet is selected, click on Next

Next, map your columns to fields in your Business Center CRM by using the fields provided. Your Thryv fields will appear, enter the name of a column on your Google Sheet to map to that column.

You will reach a confirmation screen. Click on Save to continue.

The sync will run right away, you will see a confirmation of the time completed. If you update the Sheet and need to run the sync again, return here, click Setup and Run, and complete these steps again.

Import Appointments

To start importing appointments, click on Setup and Run under Google Sheets to Thryv Appointments One-time sync.

In the next screen that appears, paste the link to your Google sheet, then click on Next

Next, select your worksheet. Use the drop-down, and select your worksheet.

Next, map your columns to fields in your Business Center CRM by using the drop-downs in the right-hand column. Select a column from your Google sheet to map that information to the appropriate field in Business Center. If there is a field for which you don't want to import data, select Skip. Remember that the following fields are required:

• Appointment Name
• Start Time
• Time Zone
• Location
• Email
• First Name
• Last Name
• Phone number

Once all fields are mapped, you will see a success screen. Click on Save to continue.

Export Information to a Google Sheet

You are able to export Contacts, Products, or Appointments to a Google Sheet as well. This can be done on a one-time basis, or you could continuously export and import from the same sheet to create a 2-way sync. Note that the sync would not be automatic as you would need to return to the app to run it manually. 

Note: Before you can export information to a Google Sheet, it must be formatted properly. Specifically, your sheet should have Headers which correspond to the fields in Business Center you wish to export. If your sheet does not have headers your information will not export.

To export information from Business Center to a Google Sheet, click Setup and Run under the desired option. 

Then, on the next screen, enter the URL of your Sheet, and select which worksheet from the drop-down. When finished click Next.

From here, you will map each field in Business Center to a Header in your sheet so that information will export correctly.

You will see a success screen. Click on Save, and your information will be exported to your Google Sheet

Uninstall

To uninstall this integration, click the Uninstall button in the top right corner.

You will reach a confirmation screen, click Uninstall one more time to confirm.

Note: Uninstalling the app will only remove the integration option and access to your Google Sheet. It will not remove any previously imported clients or products from Business Center. If you wish to delete those you will need to do so in Business Center

Don't see your question here? Ask our User Community! To create your post, or answer another user's question, all you have to do is log in with your Thryv credentials