As an experienced Zapier expert, I have worked on numerous automation projects involving Google Sheets and BigCommerce integrations. I am well-versed in setting up Zaps that seamlessly connect different platforms and automate data transfer between them. With my expertise, I can ensure that your Zaps are configured correctly and function reliably.
To fulfill your requirements, I propose the following approach:
Zap for Creating a New Spreadsheet Row:
Trigger: "New Order Created" event in BigCommerce
Action: "Create Spreadsheet Row" in Google Sheets
Field Mapping: Map relevant order data from BigCommerce to the corresponding columns in Google Sheets, such as order ID, customer information, product details, and order total.
Zap for Updating a Spreadsheet Row:
Trigger: "Order Updated" event in BigCommerce
Action: "Update Spreadsheet Row" in Google Sheets
Field Mapping: Map the updated order data from BigCommerce to the corresponding columns in Google Sheets, ensuring that the row is correctly identified for updating.
Additionally, to incorporate the 'lookup' step you mentioned, we can utilize the Zapier's built-in "Find or Create" functionality to search for an existing row in Google Sheets based on specific criteria (e.g., order ID). If a matching row is found, it can be updated; otherwise, a new row can be created.