4 ms·
Ask HN: Best way to trigger a webhook every time I swipe my AMEX?
I just played around a little with Plaid and Replit, and it seems insanely complex to get transactions from my AMEX account to trigger something like a Zapier web hook.
I want to log each AMEX transaction in a Google Sheet.
Has anybody set this up before? Easiest way?
- IgorPartola 5y agoAmex has a large purchase notification email you can set up. Have it go to a mailbox with a limit of like $0.01 if it will let you and trigger events based on when the email arrives.
- secondbreakfast 5y agoSmart idea. I want a little more structured data though, around merchant name and transaction amount.
- ev1 5y agoThe email contains card last digits, card type, merchant name, and transaction amount.
- rpier001 5y agoI expect the emails themselves are just formatted strings. You could use an email parser to get the structure back out. You or someone else mentioned Zapier webhooks, so https://parser.zapier.com/ https://parser.zapier.com/ might be extra relevant.
- secondbreakfast 5y agoAh, haven't heard of parser.zapier.com before. Yes I mentioned Zapier! This could be perfect, will report back.
- slybridges 5y agoIf Zapier Parser doesn't do the job for some reason, hit us up @ https://parseur.com https://parseur.com (co-founder here)
- reustle 5y agoI've used this for years, but I believe the minimum is $5 or $10. It's amazing how instant it is most of the time, though. Sometimes I have an email before the card is back in my wallet.
- Jugurtha 5y agoI love reading things like these. Is there a word for the mushy feeling I get when people praise something or someone? 'Giddy' is the closest I can think of, but I'm looking for a word used only in this situation.
- macNchz 5y agoYeah this would be very easy to configure with Zapier if you use an email service with filters like gmail: just set a filter rule to auto-forward the email to a Zapier parsing address and you're good to go. I get notifications from Chase for purchases > $0.
- PaulHoule 5y agoYou can get email notifications for transactions, posting those to a web hook shouldn’t be hard.
- vinceguidry 5y agoTiller may meet your needs. https://www.tillerhq.com/ https://www.tillerhq.com/
- secondbreakfast 5y agoYes this looks great.
- deleted 5y ago[deleted]
- cweagans 5y agohttps://github.com/kevinschaich/mintable https://github.com/kevinschaich/mintable may be of interest.
- secondbreakfast 5y agoAh yep. This looks amazing. Forking now.
- secondbreakfast 5y agoFollowup: Just set this up and it works perfectly. Forked the repo and made some formatting changes and set up a Github action to pull in new transactions every hour. The bonus part is I also linked my checking accounts and other credit card, so all my transactions get pulled in to a spreadsheet and formatted how I want them. Thanks for the tip.
- todsacerdoti 5y agoFree for developers - https://pipedream.com/docs/workflows/steps/triggers/#email https://pipedream.com/docs/workflows/steps/triggers/#email
- todsacerdoti 5y agoGiven AMEX offers SMS notifications, you can also use Twilio (or equivalent) as an event source and send the data to Google sheets: https://pipedream.com/apps/twilio https://pipedream.com/apps/twilio
- igammarays 5y agoIf you prefer Airtable to Sheets, try Fintable. No additional tools needed (Zapier), you get an Airtable base with an archive of your transactions and an easy API to query. With options for connecting via Plaid OR Finicity as some banks don’t work with one or the other.