We need to do some prework so that the org rep can perform the weekly member status check for people who have RSVPed on Meetup
### Prework for Status Check
- Today's Date:
- [ ] hide the comment with the last status check as resolved
- download the temporary event attendees from meetup
- [ ] open resource 1.0 (the meetup event attendees page)
- [ ] click on 'Manage attendees'
- [ ] select 'Attendee details'
- this will initiate a .csv download to your computer
- upload the temporary event attendee's downloaded spreadsheet from meetup to the team Google Drive
- [ ] open resource 2.0 (folder where download will go)
- [ ] upload the .csv from your computer
- sort the temporary sheet by RSVP date
- [ ] open the file and when prompted select 'Google Sheets'
- [ ] select the entire table and add a filter to it
- [ ] select column W to filter on and choose `Sort A to Z`
- copy the content to the primary attendee data spreadsheet
- [ ] right click on the sheet name and select `Copy to`
- [ ] then select `Existing spreadsheet`
- [ ] paste ```Hack_for_LA_Member_Summer_Potluck_Picnic_2025_event_attendees``` in the search bar of the pop up and press enter
- [ ] select the file that shows up
- [ ] click on `Insert`
- [ ] click on `Open spreadsheet` in the popup
- in case you mess up, you can open it from resource 3.0
- rename the copied sheet
- [ ] find the sheet that was just copied, it will start with `Copy` and will be at the end
- [ ] rename it using the convention `attendeesdownloaded-YYYY-MM-DD`
- [ ] move it to before the sheet named `Meetup Summer 2025 RSVPs`
- copy the new RSVPs data to working sheet
- [ ] check the sheet with the previous download date to see what the `Name` in the last row is
- [ ] go back to the latest sheet and copy the new rows (after the one you just checked)
- [ ] go to the sheet named `Meetup Summer 2025 RSVPs`
- [ ] add the number of new rows you need
- [ ] paste the copied rows in column B of the first empty row
- [ ] clear column E (Email)
- [ ] close all resources
- inform org rep that the prework is complete
- [ ] check #45 for assignee
- [ ] in a new comment, tag them and let them know that the prework for this week has been done
Overview
We need to do some prework so that the org rep can perform the weekly member status check for people who have RSVPed on Meetup
Action Items
Perform Once Weekly Till the Day Before Event
Resources/Instructions