Creates the lead spreadsheet the inbound triage templates read from, with the right tabs, headers and sample data.
Uses
Google Sheets
Inbound lead workspace setup
Set spreadsheetTitle to Inbound leads.Set spreadsheetTitle to Inbound leads.Google SheetsCreate spreadsheet spreadsheetTitle. Save it as newSheet.Create spreadsheet spreadsheetTitle. Save it as newSheet.
Trim newSheet.spreadsheet_url and save it as spreadsheetUrl.Trim newSheet.spreadsheet_url and save it as spreadsheetUrl.
If spreadsheetUrl is emptyIf spreadsheetUrl is emptyYes
Stop and report a problem: Google Sheets did not return a URL for the new spreadsheet, so there is nothing to set up. Check that the Google Sheets connection is healthy and run this again.Stop and report a problem: Google Sheets did not return a URL for the new spreadsheet, so there is nothing to set up. Check that the Google Sheets connection is healthy and run this again.No
No steps
Google SheetsCreate the tab 'New leads' in spreadsheetUrl.Create the tab 'New leads' in spreadsheetUrl.Google SheetsAdd a row to 'New leads' in spreadsheetUrl.Add a row to 'New leads' in spreadsheetUrl.Google SheetsCreate the tab 'Accounts' in spreadsheetUrl.Create the tab 'Accounts' in spreadsheetUrl.Google SheetsAdd a row to 'Accounts' in spreadsheetUrl.Add a row to 'Accounts' in spreadsheetUrl.Google SheetsCreate the tab 'Reps' in spreadsheetUrl.Create the tab 'Reps' in spreadsheetUrl.Google SheetsAdd a row to 'Reps' in spreadsheetUrl.Add a row to 'Reps' in spreadsheetUrl.Google SheetsCreate the tab 'Ledger' in spreadsheetUrl.Create the tab 'Ledger' in spreadsheetUrl.Google SheetsAdd a row to 'Ledger' in spreadsheetUrl.Add a row to 'Ledger' in spreadsheetUrl.Google SheetsAdd a row to 'New leads' in spreadsheetUrl.Add a row to 'New leads' in spreadsheetUrl.Google SheetsAdd a row to 'New leads' in spreadsheetUrl.Add a row to 'New leads' in spreadsheetUrl.Google SheetsAdd a row to 'Accounts' in spreadsheetUrl.Add a row to 'Accounts' in spreadsheetUrl.Google SheetsAdd a row to 'Reps' in spreadsheetUrl.Add a row to 'Reps' in spreadsheetUrl.
If a step below fails, save the error as deleteErrorIf a step below fails, save the error as deleteErrorTry
Google SheetsDelete the tab 'Sheet1' from spreadsheetUrl.Delete the tab 'Sheet1' from spreadsheetUrl.On error
Show in the output: Left the default 'Sheet1' tab in place - it is unused and safe to delete by hand..Show in the output: Left the default 'Sheet1' tab in place - it is unused and safe to delete by hand..Show in the output: Your lead spreadsheet is ready:Show in the output: Your lead spreadsheet is ready:
spreadsheetUrl
Next, four things:
1. Copy that URL into the 'spreadsheetUrl' setting at the top of BOTH 'Route every new sales enquiry to the right rep' and 'Chase leads nobody has picked up and nurture the not-yet-ready'.
2. Replace every REPLACE_ME__ value in the sheet. On 'New leads', use two addresses you actually control - made-up ones are correctly judged undeliverable and both leads get dropped, which makes for a dull first run. On 'Reps' and 'Accounts', put a real teammate; the Slack ID is the one that looks like U01234567, from their Slack profile under 'Copy member ID'.
3. On 'Accounts', the Domain cell must be the domain of the addresses you just put in 'New leads'. That is what sends a lead from a company someone already owns straight to that person instead of into the round robin - the most useful rule in the whole workflow, and it silently never fires if the two disagree.
4. Two sample leads are waiting on 'New leads'. One is a genuine buyer and one is an agency pitching you, so the first run shows both paths: one Slack alert with a drafted reply, and one quiet drop recorded in the Ledger.
Point your real form at the 'New leads' tab when you are ready. The column headers are the contract - the routing workflow checks them and will tell you if they drift.