Thanks for sharing your questions, here are some answers:
This, unfortunately, is currently not possible to do in Baserow. We can’t fire a webhook or trigger another event when a row enters a view.
Baserow doesn’t have a dedicated SendGrid app like Airtable but if it’s possible to import a CSV file that must be sent, then Baserow may fit your needs.
You can use n8n for this case, it’s the workflow automation platform! Try to connect Zoho with Baserow through n8n by setting a Trigger ‘a new row is added’ and Action ‘send an invoice’ (they should be available there). Check out more details on the Zoho CRM in n8n here: Zoho CRM | n8n Docs. Are you familiar with this tool?
Currently, you can create Actions only, very soon Triggers will become available as well
Maybe we have someone familiar with SendGrid here in the community, so there may be some better suggestions on how to send bulk emails using SendGrid and Baserow…
Thank you, I heard about n8n but never tried it. I will have at look it and get back to you.
I am really looking for the solution for sending bulk emails from database, not necessary sendgrid, but if you have any other solution, please let me know.
Hey @pratik! Oh, you’re right, it indeed seems that n8n doesn’t have a trigger ‘a new row is added’ (what is strange). But there should be a way to set up this automation, maybe it is worth asking on their community how to do this?
By the way, I also found that n8n has a SendGrid integration, so you probably may be able to send bulk emails by using this tool as well. Give it a try, and feel free to share your feedback here with us
Will this work if we send the data through webhook to n8n and then email is sent through Gmail?
Since Airtable has inbuilt sendgrid integration, I was using it. If I have to use third-party application, I will directly use Gmail module with Baserow.
Thank you for the answers. I guess I will have to see webhook options of Baserow.
Copy the URL from the webhook (be careful, there is two URLs, the production and test URL, select the right one, read the n8n documentation regarding this point)
Then go back to Baserow and create a webhook triggered on row creation and select the previously selected URL.
The workflow should look something like this if you use a function node to transform the data sent by Baserow before sending the email using SendGrid (or any other provider):
Don’t forget to activate the workflow so that the webhook can listen and you might need to use n8n with a tunnel to be able to test the n8n webhook in your local environment.
@jrmi Thanks for the detailed reply. This is what I thought will work. However, the detailed process you gave is going to help me a lot, as I haven’t used n8n before. Thank you again