Log Google Form intake requests in NocoDB and alert Slack

Watch my Google Form for new submissions and, for each new response, write it straight into my NocoDB intake table and notify the team in Slack. Use a poll trigger on Google Forms for new responses so this fires as soon as someone submits, and use the Google Forms List Responses or Get Response operation to pull the full answer set for the submission that triggered the run.

Map the form answers onto my intake table columns using a fixed field mapping, then use the NocoDB Create Table Records operation to add exactly one row per submission. Set the submission time column from the response's submitted timestamp, and set the status column to "New" on every row. Each answer belongs in one specific named column, so treat the mapping as configuration I can edit at the top of the workflow rather than something to infer at run time.

Once the row exists, use the Slack Bot Send a Message operation to post the key fields into our intake channel: who submitted it, the request type, a short description, and the time it came in. Route the message to a different channel depending on the request type answer, driven by a request type to channel lookup I can edit. If a submission carries a request type that is not in the lookup, post it to a default fallback channel so nothing is silently dropped.

Build this as a deterministic code workflow. Every step is a fixed field mapping or a direct lookup with no judgement calls, so no model is needed in the loop. Write the NocoDB row before sending the Slack message so a messaging failure never costs us the record. Process each response exactly once, and do not backfill historical submissions that predate turning the workflow on.