Google Sheets Integration

Connect your Google Sheets account to Paragon.

1. Add Google Sheets to Paragon

Click the "+" button in the workflow canvas and choose Google Sheets from the sidebar. Under Connect your Google Sheets account, choose "Add new account for Google Sheets" and select the Google account you want to connect to.

2. Query Google Sheets

Once your Google Sheets account is connected, you can add steps to perform the following actions:

• Get rows from spreadsheet

• Create rows in spreadsheet

• Update rows in spreadsheet

• Clear rows in spreadsheet

When using Google Sheets, you'll need to select the Spreadsheet and Worksheet you want to connect to. You'll need to make sure that the sheet you're connecting to has properly formatted column headers and a locale set to "United States". To do this, go to File > Spreadsheet settings, and select "United States" in the locale dropdown.

When creating or updating rows in Google Sheets, you can reference data from previous steps by typing {{ to invoke the variable menu.