Google Sheets Automation

  • I am currently working on automating tasks in Google Sheets.
  • I have requirements to create spreadsheets, add sheets, add rows of data, read data and delete sheets. I also have requirements is to modify the header style, and adding filters to the columns.
  • Please guide on how to achieve these tasks effectively using AutomationEdge.

@Marco_Berlusconi

You can use the google spreadsheet plugin for the same.
For more details go to plugin and click on help, you will get all information related to that plugin.

  • AutomationEdge has several out of the box Google Sheets plugin steps.
    • Google Sheets: Create Spreadsheet
    • Google Sheets: Create Sheet
    • Google Sheets: Delete Sheet
    • Google Sheets: Read
    • Google Sheets: Copy Sheet
    • Google Sheets: Get Sheet ID by Name
    • Google Sheets: Append Row
  • You can also use AutomationEdge’s GUI Automation for requirements to modify the header style, and adding filters to the columns.
1 Like