Hi,
I’m trying to create the below workflow in Zapier but got stuck as I’m not very good with Flodesk API and APIs in general.
Expected workflow:
- Create/Add a subscriber to Segment in Flodesk based on a trigger from a funnel platform.
- Create a new row in Google Sheets and pass the subscriber’s data (name, email, phone number).
- Retrieve the subscriber’s ‘Created at’ date
- If it’s before a specific date, I’d want to mark a column in Google Sheet as an old lead, otherwise, I’d mark it as a new lead.
- Fill the lead status column (new/old) in Google Sheet depending on the previous condition.
Now, I’m stuck with at step 3 and 4, because Zapier’s native integration with Flodesk doesn’t return ‘Created at’ date, so I’d need to get through a custom request and apply and IF condition which I have no idea on how to build both!
FYI: this is the Flodesk API documentation: https://developers.flodesk.com/
I’d appreciate any help!
Thanks!