Here’s a free, no-code way to email POAP links to a big group

Create your POAP

Set up a Google Form

Set up a simple Google Form for collecting emails
Create a spreadsheet to view your responses

Customize your spreadsheet

A blank spreadsheet for your responses
Create a second sheet to store your POAP links
Add your POAP links and number them
Name your ranges to keep your formulas easy to read
Name your emails column too
=arrayformula(
if(row(EMAILS)=1,
"Entry #",
iferror(match(EMAILS,unique(EMAILS),0)-1)
)
)
The first array formula
=arrayformula(
if(isnumber(C:C),
vlookup(C:C,POAPS,2),
if(isblank(C:C),,"Claim link")
)
)
The second array formula

Automating emails with Zapier

Create your first Zap
Set up a Trigger function
Configure your Trigger function
Set up your Action whenever the function is triggered
Lookup the email address that was just submitted to your form
Lookup the appropriate POAP claim link and add it to the body of the email
Turn your Zap on

Finishing up

POAPs are free digital memories

--

--

--

I write about sustainability, web3, startups, coffee, and random data projects. Cofounder of Enveritas.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Carl Cervone

Carl Cervone

I write about sustainability, web3, startups, coffee, and random data projects. Cofounder of Enveritas.

More from Medium

How To Boost Profits Using Videos As Backend Products

𝟓 𝐑𝐄𝐀𝐒𝐎𝐍𝐒 𝐘𝐎𝐔 𝐃𝐎𝐍'𝐓 𝐆𝐄𝐓 𝐑𝐄𝐒𝐔𝐋𝐓𝐒 𝐄𝐕𝐄𝐍 𝐀𝐅𝐓𝐄𝐑 𝐈𝐍𝐕𝐄𝐒𝐓𝐈𝐍𝐆…

The best 5 monetization strategies for content heavy apps and platforms

Which Is More Important, SEO or Content?