Filter Gmail Data and Append to Google Sheets

# Node Descriptions

## Retrieve Customer Messages Data (Google Sheets Node ):
**Purpose and Use Cases:**
The primary purpose of this node is to retrieve data from a Google Sheets document that contains information about messages to customers. This could be used in various scenarios, such as:

- Compiling a list of customer contacts for outreach campaigns.
- Gathering feedback or responses stored in a spreadsheet.
- Automating the process of updating customer records or tracking communications.


## Filter Items by Current Date Node:
- **Purpose:** Filters input items based on comparison with the current date.
- **Parameters:**
  - **JavaScript Code:** Compares item dates with the current date for filtering.
- **Functionality:** Ensures only items with dates matching the current date are passed along.

 ### Note : The date format should be in this form (year/month/day) to be accepted.

## Gmail Node:
- **Purpose:** Likely sends emails using Gmail based on filtered items.
- **Parameters:**
  - **Recipient:** Extracted from input data.
  - **Subject:** Extracted from input data.
  - **Email Content:** Extracted from input data.

## Update Message Status(Google Sheets Node ):
- **Purpose:** Updates specific columns in the Google Sheets document.
- **Parameters:**
  - **Operation:** Update mode.
  - **Columns:** Defines which columns to update with values from input data.

## Filter Status (Waiting for sending) Node:
- **Purpose:** Filters items based on specific status criteria.
- **Parameters:**
  - **Conditions:** Filters based on status, title, subject, email, name, and date.

## Set data Node:
- **Purpose:** Sets specified fields with extracted values from input data.

## Merge feild Node:
- **Purpose:** Merges fields from different sources based on position.

Feel free to utilize these detailed descriptions to understand and enhance the workflow further.