Schedule logo
Salesforce logo
Google Sheets logo

Workflow template

Count open Salesforce opportunities in Google Sheets

Every 10 minutes, append the scheduled time and these readings to the worksheet you choose at installation: Open opportunities. The query records a count for records visible to the connected Salesforce user. The interval adjusts to your FastHook plan minimum if it is higher.

How it works

Workflow steps

1 Trigger · 2 Actions
Schedule1 · Trigger

Every 10 minutes

Run automatically on the configured schedule.

Salesforce2 · Action

Read current metrics

Run a Salesforce Object Query Language query and return matching records.

Google Sheets3 · Action

Append the daily reading

Append one or more rows after an existing table.

Before activation

Set up your workflow

  1. Copy the template

    Open the template in FastHook to create an editable Workflow Draft.

  2. Connect your accounts

    Connect your accounts for Salesforce, Google Sheets.

  3. Review the Workflow

    Review the Steps, field mappings, routes, and provider settings.

  4. Activate

    Activate the Workflow when the Draft is ready, then verify a test run.

Questions about this template

Does the template copy someone else's credentials?

No. FastHook creates a disconnected Draft. Connect your own Salesforce, Google Sheets accounts before activation.

Can I change the Steps and mappings?

Yes. The copied Workflow is an editable Draft. Review every Step, input, mapping, and route before you activate it.

What is copied into my workspace?

FastHook recreates the Trigger configuration, Action Steps, routes, and mappings with new IDs. Provider accounts, credentials, and secrets are never copied.

When does the Workflow start running?

Only after you connect the required accounts, finish the configuration, and explicitly activate the Draft.