Write data to a Google Sheet step

https://www.youtube.com/embed/PCYHijmR0jY?rel=0&start=2315&end=2380

# What to use this step for

Use this step to output data generated by your Axioms into a Google Sheet. You will also find steps to read and delete data from Google Sheets.

You can use this step to:

  • Write scraped data to a Google Sheet
  • Transfer data stored in CSVs into a Google Sheet
  • Output repporting data into

This step features in many of our bot templates.

# How to configure the Write data to a Google Sheet step

# Spreadsheet

Search in the box for a Google Sheet or just cut and paste a URL into the field.

# Sheet name

Axiom fetches sheet names for you to select or type in a valid sheet name into the input field.

# Data

Select the data you wish to write to the Google Sheet

# Write options - Clear data before writing | Add to existing data

Select 'Add to existing data' to write the new data to the sheet without first deleting existing data; select 'Clear data before writing' to delete all data before writing any new data.

# Starting cell

To start writing to a particular cell in a Google Sheet, enter the column and row information, for example, 'D7'. You will also need to set 'Add to existing data' for this option to work.

# Write method

If you want to write formulas to the Google Sheet set this option to 'User entered'.

Prev: Read data from a Google Sheet step
Next: Append or Merge data step