Back up Hostinger Reach contacts and segments to Google Sheets daily
UnknownWhat this workflow does
This workflow has 14 nodes and runs on a schedule (every day at 07:00). Along the way it connects Google Sheets and Hostinger Api (community).
How it runs
Trigger: On a schedule (every day at 07:00).
- Set Sheet Config (Edit Fields (Set)): sets 3 fields: sheet_url, contacts_sheet_name, segments_sheet_name
- Initialize Page Number (Edit Fields (Set)): sets 1 field: page
- Fetch Segments (Hostinger Api): list segments (reach)
- Fetch Contacts Page (Hostinger Api): work with reach
- Split Segment Records (Split Out): splits a list into separate items
- Split Contact Records (Split Out): splits a list into separate items
- Set Pagination State (Edit Fields (Set)): sets 2 fields: hasMore, nextPage
- Add Sync Timestamp (Edit Fields (Set)): sets 1 field: last_synced_at
- Map Contact Fields (Edit Fields (Set)): sets 9 fields: uuid, email, name…
- If: checks a condition and branches into true / false
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-hostinger-api is verified or supports 3.0 (used in Fetch Contacts Page, Fetch Segments).
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Hostinger Api
n8n-nodes-hostinger-api.hostingerApi - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
Quick Overview This workflow runs daily at 7am to back up Hostinger Reach contacts and segments into Google Sheets, upserting records into separate Contacts and Segments tabs and adding a lastsyncedat timestamp for tracking. How it works 1. Runs every day at…