<aside> 📊 New Ground Control application experience to extend scope beyond Slingshot to other ♠️  SP applicants.

</aside>

Ground Control

🙋🏻‍♀️ PM: @caro

🧑🏻‍💻 Dev: @Deleted User

Overview

Today (Dec 2022), there is one SP sign up form for for Slingshot, one for Evergreen, and if we were to have more data programs that use the Spade engine for dealmaking (which we will), we would have to create more of these sign up forms, one for each program. Not only is this highly redundant for SPs that want to participate in more than 1 program, it’s also inefficient for Ground Control to ingest from. Therefore, we want to consolidate all these forms into one top-of-funnel Ground Control sign-up form, and Ground Control keeps only sp-list that contains the allow-listed SPs for all programs that are Spade tenants.

Goals

• Create a new SP sign up experience that expands to all SPs beyond Slingshot
• Spade can easily ingest the sp allowlist from Ground Control

Requirements

P0

• [x] Clean up the following repos where possible, rebrand them with ground-control names
  • [x] ‣
  • [x] https://github.com/data-preservation-programs/sp-kyc-checks
  • [x] https://github.com/data-preservation-programs/sp-kyc-tools
• [ ] SPs get an email notification upon approval

P1

• [x] Combine the following repos into 1 repo with 1 organizations.csv and 1 sp-list.csv
  • [x] ‣
  • [x] https://github.com/data-preservation-programs/ground-control-evergreen
• [x] sp-list.csv will have an extra column indicating which program the sp_id is allowlisted for
• [x] Move the allowlist sp-list.csv to a database (choose from Tableland, Ceramic, Polybase, postgres, pando) — using postgres - ground_control_sp
  • [x] Work with @Deleted User to have Spade ingest from this database instead of GitHub
• [x] get the github actions working again

P2

• [ ] Create a new sign-up experience on TypeForm that serves as top-of-funnel Spade SP application for PL-lead programs :
  • [ ] SPs indicate which program (aka internally as Spade tenant) they want to apply to
    • [ ] Slingshot
    • [ ] TBD
    • [ ] TBD
  • [ ] Depending on the program(s) they selected, a list of corresponding KYC questions will be asked
• [x] Ground Control reads application answers from the TypeForm instead of the current Google form
• [ ] setup n8n to connect lambda to postgres
  • [ ] email notifications for manual checks to [email protected]
    • [ ] embed an Approve button in the email for PL human to trigger add approved SP to Ground Control db.
    • [ ] embed a Deny button in the email for PL human to trigger an automatic email to inform SP applicant about
      • failing KYSP due to xyz reasons
      • call to action to change their SP operation to meet the requirements and resubmit their application