Hi everyone! I’m working on automating my job search process and running into some challenges.
What I’m attempting: I receive daily job notification emails from LinkedIn in my Gmail inbox. My goal is to use Zapier to pull out key details like position title, employer name, work location, and application URL from these notifications and store them in a Google Sheets document. I want to create an automated job tracking system.
The problem: Each notification email includes several job opportunities within the same message body (either as plain text or HTML format). I attempted using Formatter → Text Split with separators like [:newline:] or -----, but the results are inconsistent. The position title appears on the fifth line, but Zapier’s Segment Index only offers: first line, second line, last line, second to last line, and all lines as items. I’m stuck.
My questions:
Has anyone managed to successfully parse multiple job entries from one alert email?
What’s the most reliable method to iterate through and capture individual job details?
Extra credit: how do you handle emails with 5-10 different job postings cleanly?
I’d really appreciate any advice or detailed walkthroughs. Thanks for your help!
This happens all the time with structured email parsing. Skip the manual text splitting - Zapier’s Parser tool is way better. Set up a custom mailbox through Parser, forward your LinkedIn alerts there, and create extraction rules based on the HTML structure. Look for consistent patterns around each job block - usually specific spacing or HTML tags that separate listings. After Parser extracts the data, use Looping by Zapier to process each job individually before sending to Sheets. This handles variable job counts per email much more reliably than text splitting. Takes about an hour to set up but saves you tons of headaches with inconsistent parsing.
i had a similar issue with those alerts, and switching to webhooks made a huge diff! create a Gmail filter to send those emails to your webhook URL, then regex can help you extract the job info easier. way better than just splitting text.
Skip the single text split approach - you need multiple Zapier steps working together. I switched to Email Parser by Zapier instead of the regular Gmail trigger and it’s way better at handling HTML from job alerts. Then I added a Code by Zapier step with JavaScript that loops through the parsed content and pulls out each job posting separately. You’ve got to find consistent patterns in LinkedIn’s email structure - look for specific CSS classes or HTML elements that wrap each job listing. Once you isolate each job block, run separate extraction rules for title, company, location, etc. Takes some trial and error to nail the regex patterns, but once it’s set up it handles multiple postings without breaking. Creates one row per job automatically instead of jamming everything into single cells.