Kamphey, Google Sheets Wizard 🧙‍♂️
Kamphey, Google Sheets Wizard 🧙‍♂️

@Kamphey

11 Tweets 2 reads Jun 23, 2022
8 Lead Magnets For Your Community
... that you can build in Google Sheets for free.
1. Community Calendar
2. Event List
3. Coffee Chats
4. Match Making
5. Skill Share Sheet
6. Community Map
7. Content List
8. Virtual Library
1. Community Calendar
build out a unique one-of-a-kind calendar that is made up of only your communities' key dates.
2. Event List
Create a list of 100 events through out the year that only your community would love, attend, be a part of, or they host.
Take submissions
3. Coffee Chats
Create a list of people who want to meet other people over coffee.
Put in some kind of contact details or a place/time to meet for coffee.
It can be online (zoom) or (google meet) or IRL.
4. Match Making
Sign up people for a 1 time/date that they'll be matched 1-on-1 for a zoom call.
Take in people's emails via a google form. Match them and email them individually with the matches.
5. Skill Share Sheet
Create a skill share in a sheet. Take submissions from people who have unique skills they'd like to offer.
Could have a price, or a pay-it-forward ethos.
Crazy Idea: Maybe a barter system of sorts?
6. Community Map
Create an industry map of all the businesses, tools or services your community needs or offers.
See @theevuniverse
evuniverse.io
@TheEVuniverse 7. Newsletter List
Create a sheet listing every newsletter that your community should subscribe to.
Crazy Idea: Have your community rate and rank the different newsletters. Give reviews, take in a
@TheEVuniverse 8. Virtual Library
List articles, ebooks, video series that your community cares about and can learn from.
Crazy Idea: Create a book sharing tab so your community can lend to each other. If you know you're getting books, shipping is just a small cost to share.
You like these ideas?
Retweet the 1st tweet

Loading suggestions...