Creating a no-code email list that references user data from a spreadsheet
Hey, I'm looking to create my first no-code side project. It's a weekly crypto email that includes the user's crypto balance referenced from a spreadsheet and some links. I've got 2 technical questions about the setup:
- Does anyone know of an email list app that can reference user values from a spreadsheet?
None of the apps I've researched can, so I have figured out how to run this automatically using Typeform, Google Sheets, Zapier and Gmail. However, this method doesn't track open rates and links, which leads me to question #2:
- In this no-code setup, is there an easy way to track open rates and link follows?
Thanks!
you can use mailgun to track open and click, but it won't be 100% accurate since now day lots of way can use it block these tracking
Do you need to track opens? If they pay for it. and you send it. What else do you have to do?
My current plan is to make the email free and eventually use advertising and/or affiliate deals to monetize so opens would be important to track.
I sell ads now in newsletters. Been a while that I sell by CPM opens. But really... advertisers want clicks. Its much easier to sell clicks.
Just a gut feeling... but you can skip tracking opens if need be. And affiliate marketing only pays per conversion.
Cool! Thanks for the input.