Skip to Content

Write row to sheet

Add items to pipe0 sheet.

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

n/a

Output Fields

string
sheet_record_id
  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:append@1',
        connector: {strategy: 'first', connections: [{type: 'vault', connection: 'pipe0_123'}]},
        config: {
          sheet: 'sheet_id',
          run: true,
          allow_field_creation: true,
          included_fields: ['name']
        }
      }
    ],
    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));