How to Set Up the Google Sheets / Reputation Builder Integration

Easily connect a Google Sheet to your Reputation Builder account and automatically send Email or SMS feedback requests when a new customer is added to your Google Sheet.

Here’s how:

STEP 1 - Enable the Google Sheets Integration

  1. Sign in to your Reputation Builder account.
  2. Click on 'Integrations' in the menu on the left-hand side.
  3. Select Google Sheets from the list of available integrations by clicking the 'Connect' button.
  4. Click Yes, I Agree to the $0.00 charge. There is no charge for this integration.

Screen Shot 2022-04-06 at 11.07.41 AM.png

STEP 2 - Authenticate & Name Your Account

  1. Click the "New Authentication" field and enter a name. In the below example, we've entered “Taco Shop customers”.
  2. Then click the 'Create' button.

Screen Shot 2022-04-06 at 11.08.30 AM.png

STEP 3 - Sign Into Your Google Account

  1. A new window will appear, prompting you to sign into your Google account.
  2. Select the Google Account you want to be associated with this Google Sheet.
  3. Check the box to give tray.io - sheets connector access to "See, edit, create, and delete all your Google Sheets spreadsheets."

NOTE: “See, edit, create and delete all your Google Sheets spreadsheets” MUST be checked for this integration to work properly.

 

Screen Shot 2022-04-06 at 11.09.36 AM.png

STEP 4 - Set Your Preferences

  1. Next, select your Communication Preference by indicating how you will send the feedback request
    1. You can choose from email or SMS. We recommend email (that's how your account was initially set up).

Screen Shot 2022-04-06 at 11.11.08 AM.png

2. Select your "Send Feedback Request" preference
1. Choose YES to send the requests immediately after adding new customers to Google Sheets.
2. Choose No to just add customers to Reputation Builder but not send a request yet.
3. Click Finish when done.
Screen Shot 2022-04-06 at 11.11.51 AM.png

You’re all connected. Click "Got it!"

Screen Shot 2022-04-06 at 11.12.31 AM.png

STEP 5 - Check & Name Your Google Sheet

Open your Google Drive account using the same account you used in the permissions steps above. Make sure you open it in a new window (do not close out of Reputation Builder).
You should see a new Google Sheet with the title “Review Request Recipients [Date/Time]”
Important Note:
  • Do NOT edit the Column Headers (First Name, Last Name, etc) nor the Sheet Name at the bottom tab.
  • You CAN edit the document name (Review Request Recipients…).

Always add new customers after the last line in the sheet. Don't delete any that you've already added - just paste the new ones at the end.

Each row must have a customer's First Name and Last Name, plus an Email Address and/or Phone Number.

If you're using Job ID, Custom ID, or Tags, you can add them here too.

Screen Shot 2022-04-06 at 11.14.18 AM.png

NOTE: When you add a name to the Google Sheet, expect a 5 to 10-minute delay before the name is added to Reputation Builder.

Congratulations! Your Google Sheet is now integrated with your Reputation Builder account. Moving forward any contacts added to this Google Sheet will be sent a review request from your Reputation Builder account.

Step-by-Step Instructions