Pipedream Automation Experience needed for Google Calendar API
Budget: $30 – $250 USD
Using the Pipedrive platform, I need to setup the following automation for any newly created events in Google Calendar:
1. Continue the automation ONLY IF:
The event creator email inside of the Google Calendar item. See attached picture 1.png
2. Continue the automation ONLY IF:
The Event Summary in Google Calendar contains certain words. In the example, if it contains “Trial” or if it contains “Hair” then proceed. I like the current platform I am using (it is going out of business though Oct 1) as it allows to ignore case, but I can put in multiple words like Trial, trial if we can’t ignore case, no problem. See 2nd image, 2.png
*** In a perfect world, the automation would only continue now if there is a 10 digit number in the event description field, such as 5135551212
Otherwise, Twilio will error out in the next step, but this is very optional, and I don’t want to do this step if it creates a lot of programming to check that field to ensure 10 digits, and only 10 digits, nothing else.
3. Send the SMS (via Twilio, or some other SMS provider if you prefer though I already have Twilio acccount. I would like to be able to select the twilio number from my account (probably a native feature to Pipedream). Then, I would need to have the Destination phone number be +1 and then the Event Description field from Google, as that is where they are putting in client phone number for the appointment reminder. See twilio1.png attached.
If you look at the above image, it shows a Formatted Date/Time - we need that to format our date time to be May 5, 2022 and the time to be 11:20am or something similar. Something everyone in the US is used to seeing (Month-Day-Year) and then 12hr, not 24 hour.
I can only accept bids from you if you put the words at the beginning of the bid: "I understand this is not a website project" since this has nothing to do with building a website.
One last requirement is to provide me text file(s) of all the code added to complete this in case I have to make any future changes. I can provide access to my Pipedrive account upon awarding the bid. The time to complete this is flexible.
In your bid, please indicate the following:
1) Bid: please include your required bid to complete
2) Time needed to complete
3) Your experience with Pipedrive
1. Continue the automation ONLY IF:
The event creator email inside of the Google Calendar item. See attached picture 1.png
2. Continue the automation ONLY IF:
The Event Summary in Google Calendar contains certain words. In the example, if it contains “Trial” or if it contains “Hair” then proceed. I like the current platform I am using (it is going out of business though Oct 1) as it allows to ignore case, but I can put in multiple words like Trial, trial if we can’t ignore case, no problem. See 2nd image, 2.png
*** In a perfect world, the automation would only continue now if there is a 10 digit number in the event description field, such as 5135551212
Otherwise, Twilio will error out in the next step, but this is very optional, and I don’t want to do this step if it creates a lot of programming to check that field to ensure 10 digits, and only 10 digits, nothing else.
3. Send the SMS (via Twilio, or some other SMS provider if you prefer though I already have Twilio acccount. I would like to be able to select the twilio number from my account (probably a native feature to Pipedream). Then, I would need to have the Destination phone number be +1 and then the Event Description field from Google, as that is where they are putting in client phone number for the appointment reminder. See twilio1.png attached.
If you look at the above image, it shows a Formatted Date/Time - we need that to format our date time to be May 5, 2022 and the time to be 11:20am or something similar. Something everyone in the US is used to seeing (Month-Day-Year) and then 12hr, not 24 hour.
I can only accept bids from you if you put the words at the beginning of the bid: "I understand this is not a website project" since this has nothing to do with building a website.
One last requirement is to provide me text file(s) of all the code added to complete this in case I have to make any future changes. I can provide access to my Pipedrive account upon awarding the bid. The time to complete this is flexible.
In your bid, please indicate the following:
1) Bid: please include your required bid to complete
2) Time needed to complete
3) Your experience with Pipedrive
Related categories:
Automation