Spreadsheet

The Spreadsheet block in GemAutomate allows you to read, write, or clear data from a spreadsheet file. It supports both local files (Excel, CSV) and Google Sheets (Cloud).

---

How to Use the Spreadsheet Block

1. Select the Sheet Type

• Local → Use a spreadsheet stored on your device.

• Cloud (Google Sheet) → Work with an online Google Spreadsheet.

2. Choose an Action

• Read → Extract data from the spreadsheet.

• Write → Insert data into the spreadsheet.

• Clear → Remove data from specific cells.

3. Set the File Path (For Local Sheets)

• Provide the full file path of the spreadsheet.

• Example: C:\Users\Documents\data.xlsx

4. Define the Range

• Specify the cell range to read or write.

• Example:

  • Single Cell: A1

  • Column: A:A

  • Multiple Cells: A1:C10

  • Full Sheet: Leave it blank.

5. Enter the Sheet Name (Optional)

• If the spreadsheet has multiple sheets, specify the sheet name.

• Example: "Sales_Data"

6. Enable "First Row as Keys" (For Structured Data)

• If checked, the first row will be used as headers (keys for each column).

• Example:

plaintextCopyEditName   Age   Country
John   25    USA

• "Name" becomes the key for "John", "Age" for 25, etc.

7. Choose Storage Method

• Variables → Store extracted data into a variable for later use.

• Loop Data → Process each row one at a time in a loop.

8. Configure Delay for Next Block

• Delay Next Block (seconds): Adds a wait time before executing the next action.

• Example: 2 (Waits 2 seconds before proceeding).

---