Fix my 2 Zapier Zaps that create (and update) rows in Google Sheets for each BigCommerce order

I will build fluid and efficient communication for impeccable work and will offer all the help. I will automate your daily time taking task on just one click. Expertise Advanced formulas and functions Excel Charts & Graphs, Pivot Tables, Drop-Downs Excel VBA Excel Macros Userforms & Buttons Customized excel sheet with dynamic dashboard Automation in excel Google Sheet script Package Details Simple- In this package, I’ll deliver simple excel spreadsheet or I’ll set basic level formula Medium- In this package, I’ll deliver medium level excel spreadsheet & medium level formulas or excel vba Complex- In this package, I’ll deliver complex level excel spreadsheet with buttons, VBA, Macros, user forms & formulas My Motto I will guarantee quality output, professionalism, and your satisfaction I will be more than happy to stay in touch and provide assistance even after completing the job Important Please contact me before placing the order so that we can discuss This GIG is not for MAC

Hello, I have done these kind of tasks before. I had to integrate Pipedrive with Google Sheets and Update sales related info. I had to use lookups along with javascript. I have enough programming experience to pull this off. Lets discuss

I am excited to apply for the Virtual Assistant position that you have opened. I have extensive experience in Data Entry, MS Excel, and Google Spreadsheets, which makes me a perfect candidate for the role. My background in Data Entry and Online Research has allowed me to hone my skills in gathering information from the web and importing PDF files to MS Docs. Plus, my proficiency in Excel, typing, copy writing, proofreading, and web search has further prepared me for this role. As a fast-learner, I assure you that I can work with minimum supervision and deliver excellent results. You can count on me for my diligence and eye for detail in completing any task assigned to me. I am confident that my expertise and enthusiasm will be a valuable addition to your team. I hope to discuss this opportunity with you further. Thank you for your consideration. Best Regards, Louie Jean Canlas

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.