Thoughts on how to implment email triggered row creation

Ask for Help
1

I’m thinking of adding functionality to let my users add what are effectively tickets by email.

My rough plan was:

  • create a dedicated email address
  • link to Glide via either IFTT or Zapier
  • trigger action when email received
  • it from address matches a user create a row containing subject link, body text, date etc

Anything I should consider, or any better ways to do this?

2

That seems reasonable. About the only thing I’d do differently is use Make instead of the other two. But that’s mostly personal preference.

How would you match the email address? Unless you’re going to keep an external copy of your Users table somewhere, you’d need to query the Glide API each time - and that requires a Business Plan or better.

3

I’ve never used Make. I should check it out. Thanks

Hmm… good point about the plan. I’m on team plan and need to stick on that for now. I could maybe write the allowed email addresses into a spreadsheet or something. That;s a pain though.

4

One option would be to convert your Users table to a Google Sheet. Then you could query that directly with whichever integration tool you choose.

1 Like