Antlion / Components / Google Workbook
Google WorkbookIO-004
Creates a spreadsheet you can fill in by hand, with the input pages already laid out, and hands the reference to Table In and Table Out. Press Run once - the reference is saved with the Grasshopper file, so reopening it stays connected to the same workbook. After that you only edit the sheet and press Run on Table In; you do not need this component again. The 10-series pages are yours and are written only at creation; the 80-series pages belong to the plugin.
1Plan & setup
2Section
32D layout
43D solids
5Analysis
Fig. 1 — PortsReads left, writes right
Field Info FieldObject · itemOptional
Focal Point FocalPoint · itemOptional
Base Line BaseCurve · itemThe faceted line the stand is built on
Action Mode ▾ ActionText · itemWhat Run does: connect, sign in, or make a new workbook
Run Boolean · itemWire a Boolean Button
Workbook Name NameText · itemName for the new workbook
Workbook URL URLText · itemPaste a workbook address to connect to that one instead of making a new one
Book Object · itemThe workbook reference
URL Text · itemWeb address of the workbook
Debug Text · itemDeveloper diagnostic output for tracking down bugs
Colored ports carry the chain from one component to the next. The rest are values you set once. Inputs marked ▾ take a Value List: wire one in and it fills with the choices.
Inputs
- Field Info
FieldOptional. Seeds the focal-to-start-line reference the preview columns need - Focal Point
FocalOptional. Overrides the field's focal point, same as Section - Base Line
BaseThe faceted line the stand is built on. Its outward normal sets which way it faces - Action Mode
▾ ActionWhat Run does: connect, sign in, or make a new workbook (default CONNECT) - Run
RunWire a Boolean Button. Nothing goes over the network on an ordinary solve Default false. - Workbook Name
NameName for the new workbook (default Antlion Workbook) - Workbook URL
URLPaste a workbook address to connect to that one instead of making a new one
Outputs
- Book
BookThe workbook reference. Wire it into Table In and Table Out - URL
URLWeb address of the workbook - open it to fill in the input pages - Debug
DebugDeveloper diagnostic output for tracking down bugs. Copy this when reporting a problem
- Component
- IO-004
- Ribbon
- Table
- Tier
- core
- Ports
- 7 in · 3 out
- Version
- 1.0.11
- Checked
- 2026-10-05