Fresh gigs from the board on your topics — to your inbox each morning

Each day the scenario searches the board for gigs by your keywords, clears duplicates, and emails you a roundup. Every fitting gig — in one email.

  • Every new gig on your topics — right in your inbox
  • Duplicates removed, only the new stays
  • You see how many gigs per query
  • Once a day, no manual scrolling of the board
Google Sheets
Set it upScriptera

How it works

To connect Microsoft Outlook and Google Sheets, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Trigger Manual Run
  2. Then: Fetch Keywords from Google Sheet
  3. Check: Loop Through Keywords
  4. Then: Load Today’s Daily Jobs
  5. Then: Remove Duplicates by Title/Desc
  6. Then: Save Clean Job Data
  7. Then: Delete rows or columns from sheet
  8. Then: Reload Clean Job Data
  9. Then: Generate Keyword Summary Stats
  10. Then: Update Summary Sheet
  11. Then: Fetch Final Summary Data
  12. Then: Build Email Body
  13. Then: Send Daily Report Email
  14. Then: Trigger Apify Scraper
  15. Then: Wait for Apify Completion
  16. Then: Delay Before Dataset Read
  17. Then: Fetch Scraped Job Dataset
  18. Then: Process Raw Job Data
  19. Then: Save Jobs to Daily Sheet
  20. Then: Update Keyword Job Count

You can launch this Microsoft Outlook + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios