Skip to Content

Object list to sheet rows

Expand a list of nested objects into sheet rows.

Billable OperationProviderBilling Mode
Docs
Connection
Docs
Cost per operation
Docs
sheets-appendexpand-pipe0
P
pipe0
n/a
Managed

n/a

Input Fields

Output Fields

json
sheet_record_ids
  Enabled by default

const options = {
  method: 'POST',
  headers: {'content-type': 'application/json', authorization: 'Bearer <TOKEN>'},
  body: JSON.stringify({
    config: {environment: 'production'},
    pipes: [
      {
        pipe_id: 'sheet:expandappend@1',
        connector: {strategy: 'first', connections: [{type: 'vault', connection: 'pipe0_123'}]},
        config: {sheet: 'sheet_id', run: true, allow_field_creation: true}
      }
    ],
    input: [{id: '1', email: 'test@pipe0.com', name: 'John Dorr'}]
  })
};

fetch('https://api.pipe0.com/v1/pipes/run', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));