Google Apps Script API
Google Sheets can be used to extend OBS to remote interfaces.
Google Apps Script API allow you to build custom user interfaces to Google Sheets.
-
writing to Google Sheets
- Google Apps Script API doPost()
- Google Forms
- Google Forms interface
- Direct post with Fetch() by Forms ID
-
Reading Google Sheets
- Fetch() by Sheet ID
- Fetch() by Google Apps Script API
Google Apps Script Limits
Free Google Workspace accounts are subject to limitations
| Service | limit |
|---|---|
| URL Fetch calls | 20,000 / day |
| Simultaneous executions | 30 / user |
| writes per minute | 60 / minute |
| reads per minute | 300 / minute |
| Sheets Cell size | 50,000 characters |
Google Sheets notes can be used to store more than 50,000 characters.
Storing Data in Sheets
- In Cells
- vertical
- horizontal
- In Notes
Connect to Apps Script
- OBS Browser Source
- https://{hostname}?sheetID={sheetID}&gasID={gasID}?&sheetName={sheetName}&sheetRange=