Google account and databases

Administrative spreadsheets in Google Drive and subscriber data handling

The official RC42 Google account contains the forms and spreadsheets that provide dynamic data for the website. Routine content administration is conducted through four Google Sheets.

RC42 Google Drive
├── Forms
│   └── Submit a Community Contribution to ISA RC42 (Public Form)
├── Web Applications
│   └── Community Updates Subscription App
└── Core Spreadsheets
    ├── ISA RC42 Newsletter Database (Private subscribers)
    ├── ISA RC42 Community Submissions (Editorial inbox)
    ├── Active Members RC42 Social Psychology (Official directory)
    └── rc42_resources_workflow (Curated resources and publications)

The four core spreadsheets

Spreadsheet	Primary function	When to edit	Detailed documentation
ISA RC42 Newsletter Database	Private list of subscribers who opted into Community Updates email alerts.	To review subscriber records or process an unsubscription request.	Email and Community Updates
ISA RC42 Community Submissions	Editorial inbox for news, calls for papers, events, and publications submitted through the website.	To review, edit, or approve community submissions.	Community contributions
Active Members RC42 Social Psychology	Official membership database used to build the Members Directory.	To add a new member, update renewal dates, or modify affiliation details.	Members
rc42_resources_workflow	Catalog of academic journals, handbooks, syllabi, datasets, and research tools.	To add an academic resource, update links, or adjust categories.	Resources