Hello,
I’d like to create integrations from iCal appts to push to a Google Spreadsheet for a salesperson. No, I do not want to use Google Calendar, but Apple iCal. I’d like 1.) each new calendar appt address to be pushed to an existing Sheet cell. 2.) Calculate the miles once that address is in the cell. 3.) Push installation dates from iCal appt notes area to another cell in the sheet. 4.) Push commissions on the sheet back to that appt’s notes or title. I have searched and see NOTHING for iCal integrations in Zapier. Am I missing something? I’ve already got a system in place so we cannot switch calendars nor does the salesperson like Google’s Calendar so that is not an option. Is there anything else helpful for commission sales to track and sync addresses, sales, calendars, mileage, commissions, that is free? It is frustrating because I get a phone call and then have to manually enter this info and need a slicker system. Thanks