Hello @Carl_Smith , welcome to make.com community, I have worked and have experience with Make.com and l will love to collaborate with you on this you can schedule a call Here and you can checkout my upwork profile Here, for my pastworks and certifications
I’d be happy to help you build and document this Make.com workflow. I’ve developed multiple Make.com scenarios integrating APIs, BigQuery, and no-code tools like Softr, Airtable, and SmartSuite, so I’m confident I can deliver a clean, reliable solution for your stack.
Here’s how I’d approach it:
Webhook Trigger: Configure a Make.com webhook (or custom endpoint) to accept Softr’s button click and pass the row_id.
BigQuery Query: Set up a parameterized query to fetch the exact record from BigQuery.
SmartSuite Integration: Map fields precisely and send the record via HTTP POST to /records, including required Authorization and Account-Id headers.
Duplicate Handling: Add logic to prevent duplicate entries if the button is clicked multiple times.
Webhook Response: Return success/failure feedback back to Softr for a better user experience.
Documentation: Provide a clear walkthrough with mapping, authentication notes, and update instructions.
Optional Enhancements:
Log results (status + recordId) back into BigQuery for auditing.
Implement retry/error handling within Make.com to ensure robustness.
I can deliver a working end-to-end scenario with short documentation, ensuring it’s easy for your team to maintain.
Do you already have API keys and access tokens set up for SmartSuite, or would you like me to assist with that as well?
Hey @Carl_Smith , I see exactly what you need. A Softr button → Make.com webhook → BigQuery lookup → SmartSuite record creation with error handling, dedupe protection, and clean success/failure feedback back to the user. That’s the kind of end-to-end automation I specialize in.
I’ve built similar Make.com workflows connecting CRMs, APIs, and databases where the key was precise field mapping, safe retries, and clean webhook responses so the front-end experience feels seamless. I’d set this up with structured error handling, deduplication checks, and clear documentation so your team can easily update API keys or mappings in the future.
I can also add the “nice to have” logging results/status back into BigQuery so you have a full audit trail of every run.I’m looking for a Make.com expert to help me build a simple but precise API integration across my current stack.
Let’s have a chat about this. You can schedule a call with me here.
I see exactly what you need — Softr button → Make.com webhook → BigQuery lookup → SmartSuite record creation — with error handling, dedupe protection, and clean success/failure feedback back to the user. That’s the kind of end-to-end automation I specialize in.
I’ve built similar Make.com workflows connecting CRMs, APIs, and databases where the key was precise field mapping, safe retries, and clean webhook responses so the front-end experience feels seamless. I’d set this up with structured error handling, deduplication checks, and clear documentation so your team can easily update API keys or mappings in the future.
I can also add the “nice to have” logging results/status back into BigQuery so you have a full audit trail of every run.
Hi, I’m a Make.com expert with experience building precise API integrations and automations. I can help you connect Softr → BigQuery → SmartSuite so that when a user clicks a button in Softr, the correct record is fetched from BigQuery and sent to SmartSuite automatically. I also handle error prevention, duplicate checks, and can provide clear documentation for maintenance.
Hi @Carl_Smith
I can deliver an end-to-end Make.com scenario connecting Softr → BigQuery → SmartSuite with idempotency, error handling, and a webhook response back to Softr.
Implementation plan (precise + minimal)
Trigger
Make Webhooks > Custom Webhook receives row_id (primary key) from Softr button.
Validate payload; reject if missing/invalid.
Fetch from BigQuery
Google BigQuery > Execute a SQL query with a parameterized query:
SELECT * FROM <dataset>.<table> WHERE row_id = @row_id LIMIT 1
Fail fast if zero or >1 records.
Duplicate prevention
Compute an idempotency key (e.g., hash(row_id)) and check a Make Data Store (or a SmartSuite unique field) before POSTing.
If already processed, short-circuit to “Already synced” response.
Create SmartSuite record
HTTP > Make a request
Method: POST to https://api.smartsuite.com/v1/records (or your base URL).
Headers:
Authorization: Token <API_KEY>
Account-Id: <WORKSPACE_ID>
Content-Type: application/json
Body: map BigQuery fields → SmartSuite field API keys (I’ll document each mapping).