Hey guys, I would like to create this automation, or a similar one, but I don’t know how to do some of these steps:
I know the email set up and I created a filter that from gmail will automatically scrap only some type of subject email from a specific sender. And that’s easy (I already done it).
From that email then, I need to extract the datas I wrote on the notes so: Check-in date, Check-out date, Number of guests. But i don’t know how to to do it.
Once done this information extraction, I want that some kind of intelligence will understand where to put data in the google sheet. For example: If from an email I have a reservation from the 2nd of october till the 4th and there are 3 guests, i need that this kind of intelligent AI or whatever is called will understand that the cell inside the sheet called “October” that correspond to the check-in date is update with a value that say “3 guest”.
As you can see, I have a column A where there are all days as reference, now i need that this automation will recognize each month, and put the number of guest in the correct check-in date.
@Msquare_Automation thanks a lot for your help! Now I would like to create something that will match the date and update the single month. I think this type of filter will be ok. The only problem I’m thinking is that if there is a date that have number lower thatn 13 as day, this could be a problem, isn’t? I hope I explained myself.
Hi @PPM
If you want to pass only the date in November then you can apply a filter like this. Here the parseDate is used to specify the format of date you are passing and will extract the month number with formateDate function.
@Msquare_Automation Thanks, Now the automation look like this, but every 3 to 7 days I have an error from gmail module saying this: Failed to verify connection ‘Michelle - MAKE - PPM’. Invalid refresh token. Please reauthorize the connection.