Step 2: Connect Google Sheets

Retrieve lead records from your Google Sheet so the workflow can evaluate SLA status.

1. Open Retrieve Sheet Rows.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials.
3. Set Document ID to [YOUR_ID].
4. Set Sheet Name to [YOUR_ID].
5. Connect Retrieve Sheet Rows to SLA Threshold Validation.

Step 3: Set Up SLA Threshold Validation and Transform Payload

Filter records to only SLA breaches, then enrich the payload with a direct sheet link.

1. Open SLA Threshold Validation and configure the conditions:
2. Set the string condition Value 1 to {{ $json.Status }} and Value 2 to unreplied.
3. Set the date condition Value 1 to {{ new Date(Date.now() - 15 * 60 * 1000) }} and Value 2 to {{ Date.now() }} with Operation set to before.
4. Connect SLA Threshold Validation to Transform Payload.
5. Open Transform Payload and paste the JavaScript Code exactly as provided:
6. const inputData = $input.all();
7. const outputData = [];
8. for (const item of inputData) {
9. const data = item.json;
10. const passedData = {
11. ...data,
12. link: "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=[YOUR_ID]"
13. };
14. outputData.push({ json: passedData });
15. }
16. return outputData;
17. Update the sheet link placeholders in the code to your real [YOUR_ID] values.

Step 4: Configure Dispatch Telegram Alert

Send formatted SLA breach alerts to your Telegram channel or user.

1. Open Dispatch Telegram Alert.
2. Credential Required: Connect your telegramApi credentials.
3. Set Chat ID to [YOUR_ID].
4. Set Text to the full message template:
5. 🚨 SLA BREACH ALERT
6. Company: {{ $json['Company Name'] }}
7. Contact: {{ $json['Contact Person'] }}
8. Position: {{ $json['Job Title'] }}
9. Industry: {{ $json.Industry }}
10. Location: {{ $json.Location }}
11. Email: {{ $json.Email }}
12. Phone: {{ $json.Phone }}
13. Source: {{ $json['Lead Source'] }}
14. Status: {{ $json.Status === 'unreplied' ? 'UNREPLIED ❌' : $json.Status.toUpperCase() + ' ✅' }}
15. Booking: {{ $json['Booking Status'] === 'Unbooked' ? 'UNBOOKED 🔴' : $json['Booking Status'].toUpperCase() + ' 🟢' }}
16. Lead ID: #{{ $json.row_number }}
17. View Details: {{ $json.link }}
18. In Additional Fields, set Parse Mode to HTML.
19. Ensure Transform Payload connects to Dispatch Telegram Alert.

Step 5: Test and Activate Your Workflow

Verify the full SLA breach flow and turn on automation.

1. Click Execute Workflow to run a manual test.
2. Confirm Retrieve Sheet Rows returns lead data and SLA Threshold Validation outputs only unreplied leads within the 15-minute threshold.
3. Check that Dispatch Telegram Alert posts a formatted message in your Telegram chat with a working View Details link.
4. When the test is successful, toggle the workflow to Active to enable scheduled SLA notifications.