We are using Google Sheet as a CRM to manager some trasport services. Each line of the sheet is the service, while the columns are all the data involved: Service ID, customer email, name, addresses, date and times, driver details, etc.
We need the option, for each line (not batch, but e.g. possibile selecting the Service ID), to send some emails following a standard template auto-completing with fields in the relative line of the Google Sheet.
19 freelancere byder i gennemsnit €139 på dette job
I propose you to create a tool in excel. You can download the information from the google sheet and select in a dashboard the criteria. Outlook is needed to do it