I have a Table that I use for inventory/stock management. I was wondering is there a way that once a certain stock’s quantity reaches a limit (i.e. about to run out), can an email be sent out directly to use (as a reminder) or directly to our supplier to order in more stock? If this can be done internally with Airtable, that would be great. Alternatively, if not, would it be possible to use Zapier to connect our Airtable and create a zap/trigger so that once the stock quantity reaches a certain amount, an email can be sent?
I was also wondering if there was a way to connect details from standardized emails we receive and organize to have the information automated so that it is entered into my one of my tables. Again, would this be possible by connecting Airtable with our gmail using Zapier to collect the information from the email and plug in the data in certain blocks within the table?