I have set up from a template an automation so when I fill in a row on my excel spreadsheet for a tour booking, it creates a calendar event and is working fine now, had issues but sorted it.
Some bookings come from Viator so i do not have an email address for them on those bookings, my automation sends an email invite, how can I make it so if there is no email in the spreadsheet it doesn’t try to send an email invite and potentially throw back an error message or will it just not send an invite?
So to summarize your problem:
*You are creating events based on a Google Spreadsheet.
*Some attendees don’t have the correct email addresses, which causes issues.
You can use one of two approaches to solve it.
1st - Turn on the “Map” function in the “Create an Event” module and use a function,
for example:
{{ifempty(“email from sheets”; {{null}})}}
2nd - You can set up a router with filters.
This option takes a few seconds more to set up but allows you to add other steps for attendees without email addresses.
To set up a filter, you can use the option that suits you best. It can be “contains @” or you can simply use {{length}} , which will calculate the email length in the spreadsheet. It all depends on other factors and the possible data entered by the user.
Have a nice day!
4 Likes
Apologies for the late reply I have been very busy with work.
Thanks very much for the pointers, I shall see if I can work this out as I am brand new to Make.
I shall let you know if I can get this to work.
Many thanks
Ryan
1 Like
Hi There,
Sorry you will have to bear with me, I am totally new to this Make.com and not 100% sure how I am going to do this, I know how to create a Router but I am not sure where I would put the router exactly. See screenshot of my simple setup.
Do I put the router in-between the Excel Module and Google Module? or after the Google Module?
The column in the Excel spreadsheet for email is: Column L and is called Email Address.
So when I insert a booking into the Excel Spreadsheet from my website I have the travellers email address, however if they book through Viator I do not have their email address.
Whether they have an email address or not I need the Row details for the booking to be inserted into a Google Calendar Event which I have done and works fine, I just need this router to NOT send an invitation to the Viator booking I insert as there is no email address to send to, but the event is still created, if it is a direct booking then the Google Calendar Event gets created and an email sent. See my Google Calendar Module screenshot.
The following is how I have set this up, it may not be correct but maybe in the correct direction:
For some reason and I am not sure why email invitations are not being sent, it is just getting put into the calendar without an email, not sure if it is because I have used my own personal email address a few times for testing it no longer sends an email, this is another query on top of the above query.
Hi,
but I am not sure where I would put the router exactly.
Please take a look here. This article should help you understand how Make processes data.
You can also use the Explain flow button, which will show you how bundles are processed.
Getting back to your problem.
You placed the router in the correct place. Now it will split your bundles according to filter settings.
Why it isn’t working:
Please take a look here. This will explain a little how filters work.
In your case, you are trying to combine the “if” function with the filter’s condition, which is totally unnecessary.
Instead, go with a simpler filter setup:
By properly configuring your filters, the router will effectively split the data bundles according to the specified conditions.
Hope it helps!
