Библиотека / Синхронизация данных и ETL
Синхронизация данных и ETL
Синхронизация заявителей из Google Sheets в Notion и отправка писем об изменении этапов через Gmail
Работает по расписанию: копирует новых заявителей из Google Form из таблицы в общую базу Notion, пропуская дубликаты, и отправляет письма по этапам через Gmail.
Что делает
## Sync job applicants from Google Sheets to Notion and email them by stage Who's it for Small recruiting teams and hiring managers who collect applications through a Google Form and track candidates in a Notion database, and who want new applicants added automatically and stage emails sent without anyone copying rows between tools. How it works Two independent flows share one Notion database. The intake flow runs on a schedule: it reads new applicants from the Google Sheet behind your form, reads the candidates already in Notion, and drops anyone who is already there — so re-running never creates a duplicate page. Genuinely new people are added to Notion and the sheet row is marked processed, which is what stops the next run picking it up again. The email flow is triggered by Notion itself: when a candidate's stage changes, the previous stage is read from a data table and compared with the new one, the matching email template is fetched from Notion, filled in with that candidate's details, and sent through Gmail. Storing the previous stage is what makes the trigger reliable — Notion reports that a page changed, not what changed about it. How to set up 1. Create a Notion database for candidates with a stage property, and a second one holding one email template per stage. 2. Attach Notion, Google Sheets and Gmail credentials to the credential nodes. 3. Point [cred] Sheets - read new applicants at the response sheet behind your Google Form. 4. Set the stage names in route by candidate stage to match your own. Requirements A Notion workspace, a Google Sheet collecting form responses, and a Gmail account. How to customize Add a stage by adding an output to route by candidate stage and a template page in Notion. The email body is assembled in build the email from the template.
Шаги
- When a candidate stage changes
- read the previous stage
- store the new stage
- route by candidate stage
- [cred] Notion - get the stage template
- build the email from the template
- [cred] Gmail - email the candidate
- Run it now
- [cred] Sheets - read new applicants
- [cred] Notion - read existing candidates
- [cred] Notion - add the candidate
- drop candidates already in Notion
- new candidate?
- mark the row processed
Всего шагов: 16.
Похожие автоматизации
Синхронизация данных и ETLСоздание таблицы Snowflake, вставка и обновление данныхШагов: 6Синхронизация данных и ETLСоздание таблицы и вставка данных в SnowflakeШагов: 7Автоматизация эл. почтыInspect Vinted listings and log results with Google Sheets, Slack, Notion or emailШагов: 54Синхронизация данных и ETLСинхронизация изменений таблиц на веб-страницах с Google Sheets через GaffaШагов: 21