Hi - I wanted to get feedback on an idea I had to resolve a problem my colleagues and I face.
Problem - my colleagues and I subscribe to a bunch of newsletters for our industry (policy, humanitarian aid etc). And, ofc, these newsletters often have invitations to events. We want to have a central place where all colleagues (regardless of whether they subscribe to that particular newsletter or not) can review all upcoming events based on these different newsletters.
Current solution: Whoever gets an invitation to an event has to pull up a Google Sheets doc and fill out each column (date, time, location, link to register etc) manually. So, naturally, no-one likes to do it and the Google Sheet is not as useful as we would like. .
My idea in steps:
- I receive an invitation to an event from rando org via their email newsletter.
- I forward that email to a special inbox like, “record_events@myorg.com”
- A new email in the “record_events@myorg.com” triggers an add to a vector DB, like supabase.
- The content added to the DB will be all the text in the body of the invitation email.
- The add to DB will then trigger an LLM to read the latest entry and pull out all the data I need and plug it into some JSON.
- That JSON will then be sent to Google Workspace using Google Apps Script to be read and fill out the Google Sheet. (Or better, creates a Google Calendar invite to which anyone can subscribe to have automatically added to their own calendar).
Is this possible? Am I making it too complicated? Does this solution already exist?? Also, I’m making a lot of assumptions about what can trigger other processes and/or if those things can even be linked. So would like some help filling in those gaps.
Many thanks in advance!