Verified Job
Work from home
WPForm Zapier Google Sheets App Scripts
Work from home
#481841
Remote / WFH
Job Description
I am seeking a freelancer to optimize an existing workflow involving WPForms, Zapier, Google Sheets, and App Scripts.
Currently, form submissions from WPForms are processed via a Zapier automation that looks up rows in Google Sheets based on email addresses. If a match is found, the data replaces previous content in the row, which is not the desired behavior. Instead, the workflow needs to append new data to existing fields (keeping old data, separated by a "".
The current workflow is partially set up, including:
° WPForms for collecting form submissions.
° Zapier for handling the automation, with steps already configured.
° A Google Apps Script deployed to handle appending functionality, though it is not working as intended.
The task involves diagnosing the existing setup and correcting issues with appending new data in Google Sheets when a matching email identifier is found. If no match is found, the workflow is already configured to create a new row, and this aspect is working correctly.
How You Can Help:
1. Could you share your thoughts on what might be causing the issue?
2. How long do you think it would take to fix this problem?
3. What would your estimated cost be to either solve the issue or guide me through the solution?
I’d love to hear your perspective on how best to resolve this efficiently. If you're interested, please reply with your insights or a proposal. Thank you!
Currently, form submissions from WPForms are processed via a Zapier automation that looks up rows in Google Sheets based on email addresses. If a match is found, the data replaces previous content in the row, which is not the desired behavior. Instead, the workflow needs to append new data to existing fields (keeping old data, separated by a "".
The current workflow is partially set up, including:
° WPForms for collecting form submissions.
° Zapier for handling the automation, with steps already configured.
° A Google Apps Script deployed to handle appending functionality, though it is not working as intended.
The task involves diagnosing the existing setup and correcting issues with appending new data in Google Sheets when a matching email identifier is found. If no match is found, the workflow is already configured to create a new row, and this aspect is working correctly.
How You Can Help:
1. Could you share your thoughts on what might be causing the issue?
2. How long do you think it would take to fix this problem?
3. What would your estimated cost be to either solve the issue or guide me through the solution?
I’d love to hear your perspective on how best to resolve this efficiently. If you're interested, please reply with your insights or a proposal. Thank you!
