# Automate construction scheduling and procurement in Google Sheets: n8n workflow > Started by another system calling it, and works across Gmail, Google Sheets and Slack. 25 steps, 4 branches: large, and worth reading before you trust it... Source: https://millionrounds.com/workflow/automate-construction-scheduling-and-procurement-in-google-s (Millionrounds; every figure on the page links to its filing or article) [Automation library](https://millionrounds.com/workflows) · [Scheduling](https://millionrounds.com/workflows?category=Scheduling#library) # Automate construction scheduling and procurement in Google Sheets Started by another system calling it, and works across Gmail, Google Sheets and Slack. 25 steps, 4 branches: large, and worth reading before you trust it with anything live. Large [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fautomate-construction-scheduling-and-procurement-in-google-s) **25 steps** Large: read it before trusting it with anything live **4** Branches: places the flow splits **0** Loops or waits **3** Services it connects to ## The flow Starts it 3 Logic 7 Service 15 The steps in the order they run, from what starts it. - 1 **Schedule Trigger (Daily 8AM)** Schedule trigger *Starts it* - 2 **Webhook (Receive Response)** Webhook *Starts it* - 3 **Gmail Trigger1** Gmail trigger *Starts it* - 4 **Google Sheets (Read All Tasks)** Google Sheets *Service* - 5 **Google Sheets (Read for Mapping)** Google Sheets *Service* - 6 **IF (Check Subject)** If *Logic* - 7 **Code (Filter Upcoming Tasks)** Code *Logic* - 8 **Code (Map Task Dependency)** Code *Logic* - 9 **Code (Parse Email Content)** Code *Logic* - 10 **Gmail (Send Status Inquiry)** Gmail *Service* - 11 **IF (Check for Delay)** If *Logic* - 12 **IF (Validate Fields)** If *Logic* - 13 **Google Sheets (Log Delay)** Google Sheets *Service* - 14 **IF (Check for Early Start)** If *Logic* - 15 **Gmail (Place Order)** Gmail *Service* - 16 **Gmail (Send Rejection)** Gmail *Service* - 17 **Gmail (Notify Next Contractor - Delay)** Gmail *Service* - 18 **Google Sheets (Log Early Start)** Google Sheets *Service* - 19 **Google Sheets (Log On-time)** Google Sheets *Service* - 20 **Google Sheets (Log Orders)** Google Sheets *Service* - 21 **Slack (Admin Alert - Delay)** Slack *Service* - 22 **Gmail (Notify Next Contractor - Early)** Gmail *Service* - 23 **Gmail (Notify Admin - On-time)** Gmail *Service* - 24 **Gmail (Send Confirmation)** Gmail *Service* - 25 **Slack (Admin Alert - On-time)** Slack *Service* ## How it's built - **Starts on:** Another system calling it - **Steps:** 25, with 4 branches - **Size:** Large: read it before trusting it with anything live - **Connects to:** Gmail, Google Sheets, Slack - **Model:** None. This is plumbing, not judgement ## Questions What does it need to run? An n8n account, plus your own Gmail, Google Sheets and Slack accounts. You connect your own accounts after importing it; none are included. What starts it? It starts on another system calling it. Does it use AI? No. Every step is fixed logic or a call to a service, so it does the same thing every time. How long does it take to set up? Take your time. At 25 steps it is large: read it before trusting it with anything live. How do I import it? Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts. **Before you run it** Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 25 steps before you point it at anything that matters. ## Run it in n8n - **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n) - **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fautomate-construction-scheduling-and-procurement-in-google-s) - **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts. Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind. ## Connects to Each opens the other workflows that use it. [Gmail](https://millionrounds.com/workflows?service=Gmail#library)[Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library)[Slack](https://millionrounds.com/workflows?service=Slack#library) ## Workflows like it Also scheduling, with the same services where possible, closest in size first. - [**Automate subscription renewal reminders with Google Sheets** 25 steps · Google Sheets, Slack](https://millionrounds.com/workflow/automate-subscription-renewal-reminders-with-google-sheets) - [**Telegram appointment scheduler bot with Google Calendar** 25 steps · Google Calendar, Google Sheets](https://millionrounds.com/workflow/telegram-appointment-scheduler-bot-with-google-calendar) - [**AI token tracker for WhatsApp & Telegram – Save AI usage** 25 steps · calls a model · Airtable, Gmail](https://millionrounds.com/workflow/ai-token-tracker-for-whatsapp-and-telegram-save-ai-usage) - [**AI-powered meeting research & daily agenda** 25 steps · calls a model · Gmail, Google Calendar](https://millionrounds.com/workflow/ai-powered-meeting-research-and-daily-agenda) - [**Automate new customer onboarding with HubSpot** 25 steps · calls a model · Gmail, Google Calendar](https://millionrounds.com/workflow/automate-new-customer-onboarding-with-hubspot) - [**Automated customer onboarding with HubSpot and Gmail** 25 steps · calls a model · Gmail, Google Calendar](https://millionrounds.com/workflow/automated-customer-onboarding-with-hubspot-and-gmail)