Special workflows for Google Sheets.
Each scenario shows the trigger, the Volimox handoff, and the human checkpoint. These are concrete workflow blueprints, not a claim that every connection is live today.
New lead to review row
Keep a lightweight operations queue for every structured customer request.
Starts when
Volimox creates a lead that matches the selected sheet and service type.
Result
A team gets a simple, searchable lead queue without losing the source conversation.
Volimox workflow
- 01Volimox maps the lead fields to a stable sheet column contract.
- 02Volimox appends the source, summary, owner, urgency, and current state.
- 03The operator uses the row as a review queue and updates the workflow through Volimox.
Human checkpoint
Column mapping and the target worksheet are reviewed before the first write.
Status change to row update
Keep a shared operational sheet aligned with the authoritative workflow state.
Starts when
A linked Volimox lead changes state or owner.
Result
The sheet remains a useful view without becoming a second uncontrolled system of record.
Volimox workflow
- 01Volimox finds the matching row using the stable lead reference.
- 02Volimox updates only the approved status, owner, and timestamp columns.
- 03The next team member can see what changed and why in the lead timeline.
Human checkpoint
Writes are idempotent so retries do not create duplicate rows.
Supported triggers and actions.
A trigger starts the workflow. An action is the controlled operation Volimox performs after the rules pass.
Triggers
- New row
- Updated row
- New worksheet
Actions
- Append row
- Update row
- Find row
- Create worksheet
Detailed connection code.
This server-side TypeScript reference follows the same connection → action → mapped input pattern used by modern automation platforms. Provider credentials remain inside the approved connection; browser code never receives them.
TypeScript · server only
Append a lead review row
import { createZapierSdk } from "@zapier/zapier-sdk"
const zapier = createZapierSdk({
apiKey: process.env.ZAPIER_API_KEY,
})
export async function runGoogleSheetsAction() {
const { data: connection } = await zapier.findFirstConnection({
app: "google-sheets",
owner: "me",
})
if (!connection) {
throw new Error("No approved Google Sheets connection was found")
}
const result = await zapier.runAction({
app: "google-sheets",
action: "create_spreadsheet_row",
connection: connection.id,
input:
{
"spreadsheet": "{{env.GOOGLE_SHEET_ID}}",
"worksheet": "Leads",
"Volimox_ID": "{{lead.id}}",
"Name": "{{lead.name}}",
"Phone": "{{lead.phone}}",
"Service": "{{lead.service}}",
"Status": "Needs review"
},
})
return result.data
}Connection setup.
The setup path is specific to the provider. We will never ask you to paste credentials into a public page.
Google OAuth
A reviewable connection, step by step.
- 01Choose a Google Drive account
- 02Select spreadsheet and worksheet
- 03Review file access scope
This app is cataloged and its workflow contract is defined. We will enable the connection after provider access and sandbox verification.
Related apps