Browserflow
  • 👋🏽 Welcome to Browserflow
  • Guides
    • Building a flow
    • Running a flow
    • Debugging a flow
    • Sharing a flow
    • Automating Google websites
    • Keyboard shortcuts
    • Selectors
    • Variables
    • Input variables
    • Conditions
  • Browserflow Cloud
    • Running flows in the cloud
    • Loop Sheet flows
    • Saving files
    • Automating sites behind a login
    • API
    • Webhooks
    • Zapier
    • Troubleshooting
  • Reference
    • Browserflow commands
      • Interact with Page
        • Click
        • Type Text
        • Press Key
        • Scroll
        • Hover
        • Select Option
        • Set Date Input
        • Upload File
        • Handle Dialog
      • Extract Data
        • Get Element Text
        • Get Link URL
        • Get Page URL
        • Get Element Attribute
        • Get Element HTML
        • Get Clipboard
        • Save File
        • Take Screenshot
        • Generate PDF
      • Navigate
        • Visit
        • Go Back
        • Go Forward
        • Reload Page
      • Spreadsheet
        • Loop Spreadsheet Rows
        • Add Spreadsheet Row
        • Update Spreadsheet Row
        • Find Spreadsheet Row
      • Control Flow
        • Loop Elements
        • Loop Pages
        • Loop
        • Loop List Items
        • If
        • Else
        • While
        • End
        • Break
      • Tabs
        • Create Tab
        • Get Active Tab ID
        • Select Tab
        • Close Tab
      • Utilities
        • Run Script
        • Get Date
        • Wait
        • Wait for Element
        • Show Alert
        • Make HTTP Request
        • Assert
        • Run Flow
        • Comment
        • Solve Captcha
  • Support
    • Getting help
    • Common errors
  • Troubleshooting
    • Updating to the latest version
Powered by GitBook
On this page
  • Viewing the output
  • Exporting the output
  • Avoiding Overwriting Rows

Was this helpful?

  1. Reference
  2. Browserflow commands
  3. Spreadsheet

Add Spreadsheet Row

PreviousLoop Spreadsheet RowsNextUpdate Spreadsheet Row

Last updated 2 years ago

Was this helpful?

Writes a row to Google Sheets

Note: Writes to Google Sheets are batched and will occur every 5 minutes and when the flow finishes, not when the command runs

Sheet

  • Google Sheet to write to

Fields

  • Values of the output row

    • Each field represents a separate column

Viewing the output

The output of Add Spreadsheet Row can be seen in the Output tab of the .

Exporting the output

There are two ways to export the output:

  • Writing to a Google Sheet

  • Click the "Download CSV" button in the Output tab of the console

Avoiding Overwriting Rows

When Browserflow sends rows to Google Sheets to be appended, Google Sheets uses the first column of the sheet to determine where to add the rows. Please note that if the first column is empty, Google Sheets will overwrite existing rows rather than appending new rows. You can fix this by reordering the columns so that when a row is populated, the first column for that row has a value.

console