Skip to Content

Append row to sheet (dynamic)

Append rows to a dynamically provided pipe0 sheet. Optionally upsert sheets.

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

n/a

Output Fields

string
sheet_record_id
  Enabled by default
string
created_sheet
  Enabled by default

const options = {
  method: 'POST',
  headers: {'content-type': 'application/json', authorization: 'Bearer <TOKEN>'},
  body: JSON.stringify({
    pipes: [
      {
        pipe_id: 'sheet:row:append:sheet@1',
        connector: {strategy: 'first', connections: [{type: 'vault', connection: 'pipe0_123'}]},
        config: {
          run: true,
          allow_sheet_creation: true,
          allow_field_creation: true,
          new_sheet_team_id: ''
        }
      }
    ],
    input: [{id: '1', sheet: 'sheet_1'}]
  })
};

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