Email Review Request with Google Sheet

link your google sheet file containing customers' details to the platform for automated review requests via email maintain a google sheet file with 2 columns "name" and "email " whenever new clients are acquired, populate the google sheet with their contact details you can copy a template to your google drive using a link here note! you can add other variables into this template by adding new column header and input value on the next row link your google sheet file containing customers' details to the platform for automated review requests via email maintain a google sheet file with 2 columns "name" and "email " whenever new clients are acquired, populate the google sheet with their contact details automation configuration steps on the left panel, click on "automate " in the automate settings page, go to "your automations" > "automations " click on "new automation" to initiate the setup process rename the automation as you prefer, for example, "send emails " add a trigger choose an app (in this case google sheet) to send your data and select an event to initiate your automation (see " add a trigger " below for more details) add an action choose an app (in this case online reviews) to receive your data and specify an action to perform automatically (see " add an action " below for more details) add a trigger choose an app (google sheets) to send your data choose an event (new row created) to trigger your automation click on "connect your google sheets account," then "add a connection " in the "create a connection to google sheets" pop up create a unique name for your connection, then click continue we recommend using different names for your connections to avoid confusion you can change this later click "sign in with google," then select the google account you will be using click "allow" to give permission to the app to access your account select the spreadsheet and spreadsheet sheet you will be using click "add trigger" and then save the settings additional filters, actions and features additionally, you can enhance your automation by adding more action, adding filters or using tools to introduce features such as time delay time delay postpones an action for a period determined by the user, allowing the flexibility to schedule the next step in the automation adding an action click on " add action " in the add action settings pop up choose an app (in this case, online reviews) to receive the data choose an action (in this case, send email) you want to perform connect your online reviews account; leave this option as it is click "add an action" to save the changes afterward an " online reviews send email " pop up will appear match the fields with their corresponding fields in your google sheet as shown in the image below the automation setup is complete click on " start " to launch it the below confirmation message will be shown indicating your automation is complete and on you can either go to the main screen or check the automation logs