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.

Copy this template to get started :

• Google Sheets

Workflow Nodes Documentation:

1. Schedule Trigger
2. Filter Items by Current Date
3. Gmail
4. Google Sheets
5. Filter Status (Waiting for sending)
6. Set data
7. Merge feild

Workflow Overview:

The workflow begins with the "Google Sheets Trigger" node, which monitors a specified Google Sheet for new row additions. Upon detection of a new row, the workflow progresses to the "Filter Status (Waiting for sending)" node, where items are filtered based on specific conditions.

Subsequently, the workflow moves to the "Filter Items by Current Date" node, which filters items based on the current date. Items matching the current date are then processed further.

The filtered items are then forwarded to the "Gmail" node, where personalized emails are composed and sent to recipients based on the Google Sheet data. Finally, the workflow updates the Google Sheet using the "Google Sheets" node with the status of the sent emails and other relevant information.

Retrieve Customer Messages Data (Google Sheets Node ):

Purpose and structure

This folder contains the Retrieve Customer Messages Data (Google Sheets Node ): workflow. Its executable nodes use filter, gmail, googleSheets, merge, scheduleTrigger, set. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Schedule Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Schedule/0402_Schedule_Filter_Update_Scheduled.json MIT; preserve source notices.