Uses gspread to cross check two google sheets for matching values. Use Case: Sign in people using a google form to check if respondant is a member / rsvp. The results will be displayed on a column of the Sign In sheet from the google form.
Getting set up and running script:-
- Follow this guide till installing gspread.
- Clone repo and add your client secret file from step 7 to folder.
- Edit some variables in MembersCheck.py according to your google sheet names and column values.
- To quit script use control - c or kill terminal.