Create a beautiful membership application website powered by Google Sheets

Set up your membership application website and start collecting registrations right into your Google Sheets in minutes, not weeks.

@SlickEventsApp July 5, 2020

We believe that first impressions matter, so don't do the mistake of having a boring looking form on your website that just send you an email whenever someone registers their details.

If you are a not for profit organisation then being able to collect new member registrations in a smooth way should be high up on your list.

Let's find out how easy it is to start collecting your membership registrations straight into your own Google Sheet.

Create your website

First head over to Slick.events and create your free account.

Once you have done that it's quite straight forward. Simply name your first event website and hit save. What happens is that we automatically create a new Google Sheet in your Google Drive. This sheet will contain all the data about your event.

Don't be fooled by the name "event website", you will shortly transform that into your own membership application website by simply updating your Google Spreadsheet that we created for you in the previous step.

Change the content of your website

This might feel a bit strange in the beginning but all your data for your event website, including your signups, your registration form, your website text is actually stored in a Google Sheet that was just created in your Google Drive.

To update the contents of your website simply open the spreadsheet from the link in the Slick.events dashboard.

The structure of the Google Sheet

Below you find links to a section that describes each tab of your Event Google Sheet in detail

Google Sheets

Website

There are two columns in the website tab, the first column is a keyword which should not be changed, and the other is the actual text that will be shown on your membership application website.

To update your website just change the text in the cell and your website is automatically updated.

Transform an event website to a membership application website

First go ahead and delete the rows that are not relevant for you. As a suggestion we think you should just keep the following rows, make sure to update the contents of each cell to fit your needs.

Membership website rows


Some tips

The description field, you can easily insert a newline in the cell, just google for "google sheets insert new line in cell" and you will find a couple of ways of doing it.

πŸ“· To update the image you can either find a nice looking picture on www.unsplash.com, just replace the text after .com/, it's highlighted in bold https://source.unsplash.com/uW_oj3jOPRg with the id of the image that you found on unsplash. Or just download an image, add it to your personal Google Drive, share it (make sure to make it public so that anyone with the link can view it) and add the url in the image cell.

πŸ’‘ If you don't want to show a section on your website then simply remove the row. For example you might now want to show the location section for an online event, so just go ahead and remove those rows and it will no longer be shown on your website.

Use emojis - On mac you can easily insert an emoji by clicking CMD + CONTROL + SPACEBAR at the same time. On windows press and hold click the Windows button and either the period (.) or semicolon (;).

Make your website stand out even more!

If you are on one of our paid plans you can also use our premium themes which makes your application website look even nicer.

To select the premium theme simply click on the change template button in the dashboard. This is also where you can rename events and delete them.

Membership plans (Tickets)

Probably the first thing you are thinking is "how do I add and remove my membership plans?" - well, its really simple! We are going to use the concept of tickets to define your membership levels. If you want to add additional plans simply add a new row, and to get rid of a ticket simply delete the row.

Below you will find an example for when a club would like to sell some membership plans, that includes a free supporter plan. And at the same time be able to up sell some club merchandise during registration.

Membership plans and details

There are a few things to keep in mind
There is a VAT field available, if you don't want to use it simply delete the value in the cell (but keep the column!).

Qty: This basically defines how many tickets are available to sell, the Available is automatically updated whenever someone signs up and selects that ticket. When it reaches 0 it is no longer possible to sign up by selecting that ticket.
If you don't have a limit to your memberships then simply set this value to some really high number.

Currency: It's always nice to say which currency you are charging people, this is also going to be used if you enable card payments. Make sure to insert your currency 3 letter ISO code. You can find the list here: List of currency ISO codes by country.

πŸ’‘ If you want to add more tickets after people start signing up simply increase the value in the Available and Qty column.

Form (Registration form)

To add or remove fields simply add or remove lines in the form tab in your Google Sheet.

There are a few things to keep in mind

The Name and Help text columns should be quite obvious. However the name "email" is a special field that is required so don't delete this row. But feel free to change the help text of the field.

Basically the help text is written below the input field in the registration form, as an extra information field for the person signing up.

Type
This defines what type of data we are collecting, Slick events currently only support the following input fields (more are on their way):

  • email
  • text
  • number
  • select
  • info

The info type is just a text that is written inside the form, this is a great way to tell the person signing up about your privacy policy (and also linking to it).

The required column, simply insert a "y" if you want the field to be mandatory, otherwise the input field is optional.

To add a dropdown select list simply add a row with the type set to "select", then in your data column just add the different options separated by , - so for example: at the club,at the venue,at the cafe.

⚠️ IMPORTANT
Do not update or change your form fields after people have started signing up, if you do the layout of your signups tab will become inconsistent and you will have to manually sort it out and insert / update the columns based on the changes you made to your form.

πŸ€‘ Payments

Currently you can sell memberships and merchandise and collect payments by cash, or sending invoices outside of Slick.events, so this tab makes it possible to tell the person that signed up how and when they should pay for the things they selected.

We will make it possible for you to collect payments by card or bank transfer, this is something that is on our roadmap and if you want to know more send an email to hello@slick.events.

πŸŽ‰ Signups

This is where all your signups appear, initially you wont have this tab, this tab is created when the first person signs up for your event.

Once someone signs up they are presented with a confirmation page that includes the memberships they selected, the money they owe, payment message and some information about the membership.

All your signups are assigned a unique ID which makes it easy to lookup information.

There are columns added for each membership type that you have defined in the tickets tab, and we also give you a "total price" column that shows how much each person ows you.

πŸ’‘ When someone pays for their membership, simply insert a new column at the end called "amount paid" and add the amount the person paid and a column called "paid at" where you will add the date when they paid. This way you can use formulas and other Google Sheet "magic" to create interesting logic and filtering capabilities.

⬇️ You can easily search and filter your signups, simply select the first row, then go to "Data -> Create Filter".

That's it for now
—Fredrik

βœ‰οΈ Get Help

If you have any questions or would like to share your feedback then please reach out to us by sending an email to help@slick.events

Create your membership application website

Create a free account today