Setup Google Sheet and Zapier Connection
- Copy The Google Sheet Template into Your Account using: This Link
- Change the name to match the business name just to stay organized
- Setup Zapier Using This Template: Copy Template
- NOTE: If you do not already have a Zapier account you will be prompted to create one.
- Configure the Google Sheet Trigger to use the Sheet that you copied into your account
- Configure the SmartEngage Action to use your Avatar account
- Match First Name, Last Name, Email Address, and select the Trigger Tag you created: ReviewTrigger
- Turn On Zap
- Run a test by entering in a row of data in the Google Excel Sheet
- Share Edit Access of this Google sheet with the client/business owner/secretary