May 18, 2023 07:58 AM - edited May 18, 2023 08:06 AM
Building a simple library management system in AT. Would like to send an automated email reminder to folks with books overdue. Because AT doesn't allow sending emails to non-collaborators, I have to use the Gmail email action. I'm running into this error causing repeated failed runs: Precondition check failed.
I'm attaching screenshots of my automation overview and detailed shots of the Gmail portion. Thanks for any help!
May 18, 2023 08:05 AM
FYI: Airtable allows sending emails to anybody (not just collaborators) on the pro and enterprise plans.
May 18, 2023 08:07 AM
Yes, Sadly we are on the Business plan - whatever is between the free plan and the Pro plan 😞
May 19, 2023 12:15 AM
Could you provide screenshots of the relevant tables (specifically the email field and email lookup field)? If you could provide access to an example base that would be best
Your automation looks fine, so I would need to dig into your data setup to figure out what might be going wrong
May 19, 2023 08:48 AM
Hi, I appreciate the help! I felt like the automation was set up correctly, which only confused me more lol. Here are the screenshots you requested with a bit of redacting to protect our reader's privacy! I think you can see what you need to know, though! Perhaps the issue is trying to use a lookup field for the email address instead of an actual email field?
May 21, 2023 09:18 AM - edited May 21, 2023 09:35 AM
Weird! Your screenshots look fine to me too. I was wondering whether there was a timing issue where the reader record wasn't linked to this record with the "Loan ID" yet when the automation to send the email ran, but that seems unlikely
Unfortunately without access to an example base with your automations and stuff set up in it I can't help further. Might want to open a support ticket!
May 21, 2023 09:26 AM
@Ashley_Jackson Airtable support can take a very long time (i.e. several weeks) to get back to customers who aren't on the Enterprise plan. In the meantime, while you're waiting on a reply from them, I would try automating your emails using Make's Gmail modules. If it doesn't work with Make either, then you know that there's something wrong with your Gmail account. If it works with Make, then there's something wrong in Airtable.
Alternatively, if your company has a budget to pay for an expert Airtable consultant to help you with your system, feel free to contact me through my website.
May 26, 2023 04:07 PM
I'm curious, why is it that you get to have a link to your website in your signature when I've been told by the moderators here that this is against "Community Guidelines"?