How to schedule a Flow to run nightly
| Company / Service | Salesforce Flow Builder (declarative automation) |
|---|---|
| Category | Top 50 Global Companies |
| Guide type | Procedure |
| Skill level | Intermediate to advanced |
| Time | 15 - 60 minutes including verification |
Engineers and integrators running Salesforce Flow Builder (declarative automation) hit How to schedule a Flow to run nightly often enough that there is a stable fix pattern. This page captures it in the order an experienced API consumer would run it during a real production incident.
What how to schedule a flow to run nightly actually involves on Salesforce Flow Builder (declarative automation)
This task on Salesforce Flow is one of the more searched operational topics across vendor forums and Tom's Hardware in the last 12 months. The procedure below is the path that works on a current Salesforce Flow setup with default config.
The rest of this page is the structured fix path. Start with diagnose, then remediation, then the automation options so you do not have to do this by hand the next time it surfaces. Verify and safety sections at the end are the discipline that keeps the fix from regressing in production.
Diagnose first, fix second
Fourth: open the vendor status page on the Salesforce Flow Builder (declarative automation) (status.stripe.com, status.salesforce.com, status.cloud.google.com, status.aws.amazon.com, status.atlassian.com, status.slack.com, downdetector.com as a cross-check) and the vendor X/Twitter status handle (@StripeStatus, @awscloud, @Atlassian) for the failing window. The smoking guns are an open incident touching the exact service and region you are calling, a recent post-mortem covering the same error, or a Trust Center advisory on a partial outage. Cross-reference the timestamp of your first failed correlation id against the incident start time - if they match within 5 minutes, stop debugging your code and subscribe to the incident updates. Many vendors lag the status page behind the actual incident by 10 to 30 minutes; if Twitter and Reddit are both lit up but the status page is green, trust the crowd and treat it as upstream until proven otherwise.
Fifth: replay the failing call against the Salesforce Flow Builder (declarative automation) sandbox or test environment with curl -v (or Postman with the same Authorization header), then capture the full request and response including headers. Pin the API version explicitly: Stripe-Version header (for example 2024-12-18.acacia), Salesforce v60.0 in the URL path, Apple App Store Connect API v1.X, Slack Web API method name, GitHub REST v3 vs GraphQL v4, LinkedIn Marketing API version header. The version pin is what isolates "their rollout broke me" from "my client SDK is old." Use HTTPie for terminal readability (http --print=HhBb POST), or import the cURL into Postman to inspect against the saved environment. If sandbox passes and prod fails with the same payload and the same API version, you have a prod-only data condition (real customer ids, real currency, real geo) and the fix is to capture that exact prod record and rerun against a sandbox tenant seeded from it.
Sixth: pin down the latency and error envelope on the Salesforce Flow Builder (declarative automation) under real load. Run a long-duration soak via k6 / JMeter / Postman Runner / Newman CLI for 30 minutes against the failing endpoint at production-realistic RPS, log status code, latency p50/p95/p99, correlation id, and rate-limit headers (X-RateLimit-Remaining, Retry-After, x-ratelimit-reset) per response to CSV. Watch for the breakpoint where p99 latency climbs past 1500ms and the 429 rate starts to bend - that is your true safe RPS for this token / app / tenant, regardless of what the docs claim. Apply weighted jitter on retries (full jitter, base 200ms cap 30s) so you do not synchronize retry storms across instances. Capture the breakpoint in a runbook next to the Stripe API version, the Salesforce v60.0 pin, and the OAuth scope set - the next on-caller needs all three to reproduce.
Solution-focused remediation path
Before any destructive step on a Salesforce Flow Builder (declarative automation) integration, slow down and stage rollback. Snapshot the current SDK lockfile, the API version header, the OAuth scope set, the webhook signing secret, and the current IAM policy / permission set to a runbook entry first. Capture the failing correlation id, the vendor incident id if any, and the timestamp window. Photograph (screenshot) the admin console state from two angles: the integration page and the audit log of the last 24 hours. Then do the destructive step (rotate the key, drop a scope, push a new SDK pin) inside a feature flag or a single tenant first, never the whole fleet. Capture the SDK version, the API version, the OAuth scope list, the IAM policy version, and the webhook delivery log snapshot to the runbook before the destructive step. Decision point: if you are on a paid SLA plan, the cheapest correct path is almost always to open a support case via the vendor portal in parallel with the rollback - the support engineer can confirm whether a vendor-side rollout is responsible while you are still staging the change, which avoids a needless code revert if the fix is server-side.
When the Salesforce Flow Builder (declarative automation) integration returns intermittent 5xx, gateway timeouts, or "service unavailable" under normal load, suspect the vendor before blaming your code. Subscribe to the vendor status page RSS / webhook (status.stripe.com, status.salesforce.com, status.atlassian.com, status.aws.amazon.com) so an open incident lights up your on-call channel automatically. Cross-check the vendor Trust Center for any planned maintenance window covering your region. Listen to the vendor X/Twitter status handle (@StripeStatus, @awscloud, @SalesforceHelp) - many incidents land there 15 to 30 minutes before the formal status page update. Decision point: if the status page is green but your correlation ids are all returning 503 from the same region or POP, fail over to a secondary region (AWS us-east-1 to us-west-2, Stripe API to the regional endpoint) and open a support case with the failing correlation id and the timestamp window; Stripe, Salesforce, and AWS support all accept the request id as the primary trace key. Screenshot the failing request in DevTools Network tab with the response headers visible before the regional failover - that screenshot is what the support team asks for first on any latency or 5xx claim.
Start by sorting the Salesforce Flow Builder (declarative automation) failure into one of three buckets, because roughly 80% of cases fall here. Bucket one is auth/config drift: an API key rotated, an OAuth scope dropped, an IAM policy tightened, a tenant moved. Bucket two is SDK or API-version mismatch: client library against deprecated endpoint, Stripe-Version header behind the dashboard default, Salesforce v59 client against a v60 metadata change. Bucket three is rate / quota / billing: Twilio 20429 sustained throughput cap, AWS ThrottlingException at the per-account TPS, Google Ads CAMPAIGN_BUDGET_NOT_ACTIVE, AdSense AD_CLIENT_DISABLED. Pick the bucket first, then act. Before you act, capture a baseline correlation id with curl -v plus the request/response pair so you can prove whether the fix actually moved the needle. Decision point: if the failure is intermittent and you are on a paid Business / Enterprise / Premier plan, open the support portal first - vendor support on an SLA-covered tenant beats hours of speculative debugging on cost and on liability if the failure recurs.
Automate this fix so you do not do it twice
Scrape vendor admin audit log + webhook delivery via scheduled job
For the Salesforce Flow Builder (declarative automation), integration faults usually surface as failed webhook deliveries, audit-log denials, or rate-limit 429 bursts before a full outage. A weekly scheduled job that exports the last 7 days of these events to CSV gives you a paper trail to correlate with SDK bumps, scope changes, and vendor incidents without staring at the admin console live. Register the task via cron (Linux), Windows Task Scheduler (schtasks /create /XML), or a GitHub Actions schedule, then write the CSV to S3 / GCS / OneDrive for retention. Subscribe a SIEM (Splunk, Datadog, Elastic) to the same bucket so audit events from every Salesforce Flow Builder (declarative automation) tenant converge on a single dashboard without per-tenant scraping.
# Stripe Events via curl (last 7 days)
curl -G https://api.stripe.com/v1/events \ -u sk_live_XXXX: \ --data-urlencode "created[gte]=$(date -d '7 days ago' +%s)" \ --data-urlencode "limit=100" \ -o stripe-events-Salesforce Flow Builder (declarative automation).json
# Salesforce Setup Audit Trail (sfdx)
sfdx force:data:soql:query \ -q "SELECT CreatedDate, Action, Section, CreatedBy.Name FROM SetupAuditTrail WHERE CreatedDate = LAST_N_DAYS:7" \ -r csv > sf-audit-Salesforce Flow Builder (declarative automation).csv
# GitHub webhook deliveries (gh CLI)
gh api -X GET "repos/OWNER/REPO/hooks/HOOKID/deliveries" --paginate > gh-webhook-Salesforce Flow Builder (declarative automation).jsonCodify the SDK pin and rollback as a single git revert
Once a stable SDK and API version is identified for the Salesforce Flow Builder (declarative automation), commit the lockfile to a runbook repo with the date, the API version header, and the OAuth scope set in the commit message. Reproducible rollback is then a single git revert plus npm install or pip install. Pin the API version in the Authorization or version header explicitly so a vendor-side default change does not silently shift behavior under you. Stage the pinned dependency manifest next to a README that lists the failing correlation id, the vendor incident id (if any), and the support case number; the second time the integration breaks at 2 a.m. you do not want to be rediscovering which SDK version was actually green.
# package.json (Node)
# "stripe": "14.21.0", // Stripe-Version: 2024-12-18.acacia
# "@aws-sdk/client-s3": "3.620.0"
npm uninstall stripe && npm install stripe@14.21.0
# requirements.txt (Python)
# boto3==1.34.51
# twilio==9.3.0
pip uninstall -y boto3 && pip install boto3==1.34.51
# Salesforce CLI pin
sfdx force:doctor
# Tag the runbook entry: 2026-05-31_Salesforce Flow Builder (declarative automation)_v60.0_scopes_offline_accessAutomate vendor diagnostic + token validation via vendor CLI
On the Salesforce Flow Builder (declarative automation), regular token + scope snapshots catch silent OAuth scope drift, IAM policy tightening, and expired access keys well before the integration starts 401-ing in prod. Pair vendor CLI health checks (sfdx force:doctor, gcloud auth list, az upgrade --check, aws sts get-caller-identity, kubectl version) with a jwt.io-style decode of the active access token so both vendor-side and client-side issues land in one folder. Run the scheduled task on a control plane node (an EC2 instance, a GitHub Actions runner, or a Cloud Function) under a tightly scoped service account that mirrors prod least-privilege.
# AWS - prove which IAM principal the SDK actually picked up
aws sts get-caller-identity > whoami-Salesforce Flow Builder (declarative automation).json
aws iam simulate-principal-policy \ --policy-source-arn $(aws sts get-caller-identity --query Arn --output text) \ --action-names s3:PutObject --resource-arns arn:aws:s3:::my-bucket/*
# Salesforce - org limits + doctor
sfdx force:limits:api:display --json > sf-limits-Salesforce Flow Builder (declarative automation).json
sfdx force:doctor --outputdir ./diag-Salesforce Flow Builder (declarative automation)
# Google Cloud - active credential + IAM policy
gcloud auth list --format=json > gcp-auth-Salesforce Flow Builder (declarative automation).json
gcloud projects get-iam-policy $GCP_PROJECT --format=json > gcp-iam-Salesforce Flow Builder (declarative automation).json
# Azure - role assignments for the signed-in principal
az role assignment list --assignee $(az ad signed-in-user show --query id -o tsv) -o json > azr-iam-Salesforce Flow Builder (declarative automation).json
Common pitfalls and what to watch for
Read-only validation before any write is the single step most Salesforce Flow Builder (declarative automation) fixes skip, and it is the step that lets you roll back when a fix backfires. Screenshot every existing admin console page (the integration settings page, the webhook config, the OAuth app page, the IAM policy editor), capture the failing correlation id (x-request-id, x-amz-request-id, X-Salesforce-SFDC-RequestId) in a runbook entry, export the webhook delivery log to CSV, and screenshot the audit log filter showing the failing window before any change. On Salesforce Flow Builder (declarative automation) tenants with multiple environments record the API version header, the SDK version, and the OAuth scope set in each environment before toggling anything, because a "fix" pushed only to staging is a known regression vector when prod has a different scope list. On payment-processor integrations screenshot the Stripe Idempotency-Key reuse or the Visa 3DS ARES response before retrying.
The mirror-image mistake is confusing a user-side symptom with a vendor fault on Salesforce Flow Builder (declarative automation). A persistent Salesforce 403 is often an OAuth scope dropped on the Connected App rather than a permission set bug. A Stripe 402 decline can be a Mastercard decline 05/14/51 from the issuing bank rather than a Stripe-side problem. A "webhook not firing" is frequently a corporate proxy or firewall dropping the vendor egress IP rather than a vendor-side regression.
Verify the fix worked
- Reproduce the original failing call against Salesforce Flow Builder (declarative automation) sandbox AND prod with the same payload. If the failing status code (Stripe 402, Salesforce INSUFFICIENT_ACCESS_OR_READONLY, AWS ThrottlingException, Webex 41001) still surfaces on any tenant in the fleet, you have not fixed it.
- Watch for 24 to 48 hours via the vendor admin console audit log + the webhook delivery log + your SIEM (Splunk, Datadog, Elastic). Cached error responses and CDN caches mask slow-burn drift and intermittent regional issues.
- Smoke-test under realistic load: replay against the vendor sandbox with k6 / JMeter / Postman Runner / Newman CLI for at least 30 minutes at production RPS, log p50/p95/p99 latency, status code, and rate-limit headers per response.
- Capture the new state in a runbook so the next on-caller does not rediscover this. Note SDK version + API version header + OAuth scope set + failing correlation id (x-request-id, x-amz-request-id, X-Salesforce-SFDC-RequestId) + verbatim error string + fix applied. Push to a shared wiki.
- If the fix involved an API key rotation or OAuth scope change, commit the new lockfile and scope list to the runbook repo and screenshot the admin console state for archival.
Safety, rollback, blast radius
- Test in the Salesforce Flow Builder (declarative automation) sandbox first or behind a feature flag before any write that touches a prod tenant. Snapshot the SDK lockfile, the API version header, the OAuth scope set, and the IAM policy version before changing anything.
- Apply principle of least privilege when granting OAuth scopes or IAM roles. Review the scope list against the endpoints you actually call - extra scopes are extra blast radius.
- Stamp an idempotency key (Stripe Idempotency-Key, AWS ClientToken, Atlassian X-Atlassian-Token) on every retried POST so a retry storm cannot create duplicate charges or duplicate records.
- Know your rollback path. SDK pin rollback is a one-line git revert plus npm install / pip install; an API key rotation is reversible if you kept the old key Active during cutover; a webhook signing secret rotation is reversible only if you saved the previous secret in the secrets manager.
- For tenant-wide or org-wide changes, line up a maintenance window with stakeholder notification before pushing through Salesforce Setup, Microsoft 365 Admin Center, Google Workspace Admin, AWS Organizations, or Adobe Admin Console.
FAQ
References
- Vendor developer documentation for Salesforce Flow Builder (declarative automation) (official API reference, SDK changelog, Trust Center)
- Developer forums (Stack Overflow, r/webdev, r/devops, r/sysadmin, vendor community Slack / Discord, brand-specific forums)
- Vendor status pages and X/Twitter status handles, vendor changelogs, and post-mortem incident reports
- OpenAPI / Swagger specs, OAuth scope reference, and admin console audit log documentation
Related fixes
Related guides worth a look while you sort this one out: