Please help me build this intelligent scenario

Reservation update scenario. Read Below :arrow_down:

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:

  1. 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).

  2. 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.

  3. 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”.

  4. The notification, I know how to do it.

Update, I have created this, and I can extract the needed data


Now it’s time for fun, anyone can help me?

Hi @PPM

Can you provide the sheet along with example data, indicating which column each data point should be added to?
Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

Sure, and thanks for the reply @Msquare_Automation

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.

Hi @PPM
Sample workflow
image

First we have to srearch for the row with checkin date:
Please ensure the date format is consistent between the sheet and the incoming data

Update the retrieved row with no. guests.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

@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.

Best regards,

Msquare Automation
platinum of Make
@Msquare_Automation

1 Like

@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.