This template inserts a Microsoft SQL Server row each time a message hits Mailhook.
Forward or send mail to the Mailhook address, map subject, sender, date, and body in JavaScript, then insert the row. Connect Microsoft SQL Server and put the database password on that connection. This uses inbound email, not a calendar feed.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts when a message arrives at the Mailhook address.
JavaScript reads subject, sender, date, and body so each value lines up with a column.
Microsoft SQL Server inserts those fields into the table you choose.
Add a Mailhook trigger and copy the inbound address. Forward or send the emails you care about to that address.
Add a Microsoft SQL Server connection with host, database, user, and password. Use a table with columns for the fields you want to store.
In JavaScript, return stable field names that match your columns, then insert a row. Send a test email to Mailhook and confirm the new row.
FAQ
More templates
This template runs on a schedule, opens each URL in a headless browser, and compares visible text to the last snapshot in Latenode Database. When the change crosses your threshold, JavaScript builds RSS XML and Google Drive saves the feed file. Connect Google Drive. Keep snapshots in Latenode Database keyed by URL.
This template receives Cognito Forms submissions on a Latenode webhook, maps the payload, then creates or updates the contact in ActiveCampaign and applies a tag. Paste the webhook URL into Cognito Forms. Connect ActiveCampaign and put the API URL and key on that connection. Map email so matches update the same person.
This template watches a Discord channel for new messages, translates the text with Google Cloud Translate, and posts the translation back to Discord. Connect a Discord bot and Google Cloud Translate. Put the Translate API key on the Google Cloud Translate connection. Point the trigger at the channel you want to translate and pick the target language.
