Just wrapped up my OpenFn email automation workflow!

1

After 5+ hours of testing and refining, I got it working, fetching unread Gmail messages, extracting key info, and logging everything neatly into Google Sheets.

:wrench: Fixes & Wins:

image
image2860×1388 477 KB

  • Handled .map() on undefined by using safe fallbacks
  • Switched from updateValues() to appendValues() for Sheets
  • Improved email parsing for consistent data logging

Lessons Learned:

  • Always check your state variables!
  • Read adaptor docs — they’ll save your day
  • OpenFn’s error logs are gold when debugging

:pushpin: Next up: scam detection logic + alerts + packaging it as a template for NGOs

Check out the repo :backhand_index_pointing_right: GitHub - Centpizzy-cloud/GreenTEK-OpenFn-Email-Workflow: A smart automation project using OpenFn to filter, log, and organize emails into Google Sheets.

1 Like
2

So great! Welcome on board. I hope this can be helpful to some clients very soon! Good luck taking it to help people and I hope you find some real implementation use cases asap :slight_smile:

1 Like