The core use case of the Google Sheets action is adding data from a record in your Clay table directly into a row in your Google spreadsheet.

1. Know the key terms in Sheets.

   Let's take a look at our sample Google spreadsheet:

   • Sheet ID: the sheet ID can be found in the URL of your Google spreadsheet. In this case, the sheet ID is "1dvf_nK48eAqUxet9EUKHhh5VT86M9GY5vNP-8V5XDjg".
   • Worksheet Title: the worksheet title can be found at the bottom lower left of the screen, where all worksheets are located. In this case, the worksheet title is "Test".
   • Header Row: the header row acts as the column names that Clay interprets. In this case, the header row contains 4 columns with the labels "a", "b", "c", and "d".

2. Auth into Google Sheets

Similar to how you would for any action, auth into your Google account to access your Sheets.

<aside> ☝ Note: it's important that your Google spreadsheet be created in the SAME account you auth-in with or Clay won't have permission to view/modify your spreadsheets.

</aside>

3. Configuring your inputs.

After you auth-in, you can start configuring the inputs to the action, using the example below.

A. As a first step input the Sheet ID and the Worksheet Title. Step 1 above outlines where to find these two attributes in your sheet.

B. Once the Sheet ID and Worksheet Title have been entered, you'll see new inputs appear dynamically, namely inputs for each of the columns specified in the Header Row.

<aside> ☝ NOTE: If the dynamic fields do not immediately appear you may need to auth in again, as Google Suit authorizations do timeout ⌛️

</aside>

4. Navigate over to your Google Sheet and you'll see that the row has been successfully added!