# google-formify

> Get Google Forms results in Node.js

Latest version **1.0.2** (published 2021-06-14) · MIT license · 0 weekly downloads

## Install

```sh
npm install google-formify
pnpm add google-formify
yarn add google-formify
bun add google-formify
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.2 |
| Published | 2021-06-14 |
| First published | 2021-05-26 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 2 |
| Unpacked size | 5.9 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 5 |
| Author | YodaLightsabr |
| Maintainers | yodalightsabr |
| Keywords | csv, google, google-forms, json, http |

## Links

- npm: https://www.npmjs.com/package/google-formify
- Repository: https://github.com/YodaLightsabr/formify
- Homepage: https://github.com/YodaLightsabr/formify#readme
- Issues: https://github.com/YodaLightsabr/formify/issues
- npm.io page: https://npm.io/package/google-formify

## Dependencies (2)

- [node-fetch](https://npm.io/package/node-fetch.md) ^2.6.1
- [@fast-csv/parse](https://npm.io/package/@fast-csv/parse.md) ^4.3.6

## Alternatives

- [@mapbox/jsonlint-lines-primitives](https://npm.io/package/@mapbox/jsonlint-lines-primitives.md) — 5.3M weekly downloads
- [reftools](https://npm.io/package/reftools.md) — 3.5M weekly downloads
- [@hey-api/openapi-ts](https://npm.io/package/@hey-api/openapi-ts.md) — 3.5M weekly downloads
- [@mapbox/geojson-rewind](https://npm.io/package/@mapbox/geojson-rewind.md) — 2.4M weekly downloads
- [turbo-stream](https://npm.io/package/turbo-stream.md) — 1.7M weekly downloads

## Recent versions

- 1.0.2 (latest) — 2021-06-14
- 1.0.1 — 2021-06-14
- 1.0.0 — 2021-05-26

## README

# Formify
Get Google Forms results in Node.js

## Setup
1. Make a Google Form
2. Send responses to a Google Sheet
3. File > Share > Publish to the web
4. Copy `.csv` URL

## Fetch responses
This is the simplest way to load responses.
```js
const { Spreadsheet } = require('google-formify');
const spreadsheet = new Spreadsheet('https://docs.google.com/spreadsheets/d/e/2PACX-1vQ5_Tq3nv**********************************************************************/pub?gid=1409162307&single=true&output=csv');
spreadsheet.load().then(console.log);
```

## Collect responses
You can collect responses by checking every 10 seconds and logging new ones to the console.
```js
const { Spreadsheet } = require('google-formify');
const spreadsheet = new Spreadsheet('https://docs.google.com/spreadsheets/d/e/2PACX-1vQ5_Tq3nv**********************************************************************/pub?gid=1409162307&single=true&output=csv');
spreadsheet.responseCollector(10000).on('response', console.log);
```

## Get UUIDs
UUIDs are unique identifiers added to each response that will always be the same for each response and always be unique from other responses.
```js
const { Spreadsheet } = require('google-formify');
const spreadsheet = new Spreadsheet('https://docs.google.com/spreadsheets/d/e/2PACX-1vQ5_Tq3nv**********************************************************************/pub?gid=1409162307&single=true&output=csv');
spreadsheet.uuids().then(console.log);
```

---
_Source: https://npm.io/package/google-formify · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._