A web microservice allowing users to authenticate via osu! and Discord before being redirected to Google Forms with pre-filled authentication fields.
forked and rewritten from ThePoon's form auth https://git.cartooncraft.fr/osufrlive/form-auth
- Try the example at: https://auth.hoaq.works/forms/example
- The results can be seen at: https://docs.google.com/spreadsheets/d/1p55DN60LHmdaPfiLyB2CTCpmGgYYGn_qywMRGMfCVDk/edit
soon:tm:
- Install Bun: https://bun.sh/docs/installation
- Clone the repository and install dependencies:
git clone https://github.com/vncommunityleague/vcl-form-auth.git
cd vcl-form-auth
bun install- Build and run the server:
bun run build
bun run startIn your Google Forms response sheet, open the Apps Script and add the following code:
const BASE_AUTH_URL = "https://auth.hoaq.works";
function verify(formId, verifyToken, osuId, osuUsername, country, performancePoint, globalRank, countryRank, discordId, discordUsername) {
return UrlFetchApp.fetch(`${BASE_AUTH_URL}/forms/${formName}/verify`, {
contentType: "application/json",
payload: JSON.stringify({
osu_id: osuId,
osu_username: osuUsername,
country: country,
performance_point: performancePoint,
global_rank: globalRank,
country_rank: countryRank,
discord_id: discordId,
discord_username: discordUsername,
verify_token: verifyToken,
}),
}).getContentText();
}Replace BASE_AUTH_URL by your deployment URL.
Add a column and fill it with the following formula:
=VERIFY("example", J2, B2, C2, D2, E2, F2, G2, H2, I2)