Get customers
Answer customers
Work for you
Reach people
Give agents tools
Run and ship
Manage sheets, import columns, destinations, validation and transforms
List one page of sheets owned by the API user; use page to continue.
2 fields
Read a sheet's columns, scripts and importer settings.
1 field
Create a sheet importer. Every supplied script item is created.
10 fields
PUT updates supplied fields. Supplied script collections replace stored collections: omitted items are deleted, and [] clears the collection.
11 fields
PATCH changes only supplied fields. Script collections merge named items; [] is a no-op and _delete removes a named item.
Change only the sheet title.
Set the sheet's column definitions and built-in validation rules.
Configure the destination receiving imported rows.
Configure the import-completion webhook.
Configure upload, mapping, verification and result-screen settings.
Configure region, allowed domains and upload security settings.
Merge computed columns by column_name; _delete removes one and [] is a no-op.
Merge validators by function_name. Omitted code and scope fields are preserved on existing items; _delete removes one.
Merge transforms by transform_name. Omitted fields are preserved on existing items; _delete removes one.
Replace the PDF/DOCX metadata extraction configuration; [] clears it.