Halyna Demko
Offer Halyna work on your next project.
Rating
Language proficiency level
Skills and abilities
Programming
Design & art
Promotion
Portfolio
-
60 USD Zapier - Team Reminders
Enterprise Resource Planning (ERP)1. Schedule by Zapier — Every Day
This is the trigger: the Zap starts at a specific time without any human involvement.
2. Google Sheets — Lookup Spreadsheet Row
… After the Zap starts, it accesses Google Sheets and performs the action:
Finds the required row in the spreadsheet based on a specific criterion (such as date, name, ID, etc.).
This means it locates one record from the entire sheet that will be used in the next step.
3. Gmail — Send Email
When the required row is found, the system:
automatically generates an email,
inserts the data from the found row, sends the message via Gmail.
-
60 USD Zapier - Dispute Email
Enterprise Resource Planning (ERP)1. Google Sheets — New or Updated Spreadsheet Row
This trigger monitors changes in the spreadsheet.
2. Filter by Zapier — Filter conditions
… After the Zap starts, a filter is applied.
At this stage, the system checks:
whether the data in that row meets specific conditions
If the conditions are met, the process continues.
If they are not met, the Zap stops.
3. Gmail — Send Email
If the filter passes the data, the Zap continues:
an email is generated,
the information from Google Sheets is inserted into the message,
Gmail automatically sends the email to the required address.