Webhook between Google form, Sheets and Zoho Books to deliver realtime payment link redirection on form submission
Budget: $50 – $150 SGD
I am trying to
1. redirect users to a payment URL page after google form completion,. The URL is generated only after Googleform Completion and webhooks are sent to ZOHO Books/Flow with google form fields to automate payment link geeneration
2. Find a way to track conversion and source/campaign for analytics and google for my embedded Google Form on my website
No invoice creation required just API Calls/webhooks to send data to activate existing automation workflow from google form fields sent, and grab corresponding final created invoice payment link created by ZOHO to redirect user to pay immediately
1. After google form submission , create a page or pop up text to hold clients for 5-10 seconds during workflow (ie "Submitting Order", "Redirecting you to Payment Page")
2. Create backend form script to Send googlesheet fields on new row added via form payload to Webhook to ZOHO FLow to activate existing workflow which will create a payment link (ZOHO automation)
3-Find corresponding payment URL created from ZOHO, which was created after webhook. (matching order no field in Google sheet and ZOHO Books Invoice field)
4. Redirect users to the Payment URL immediately when available which may take 4-10 seconds on average
5. On payment completion (via checking Invoice status is paid) and show payment confirmed message and redirect back website + Send payload to facebook and google analytics for conversion to track source / campaign success
6. If failed, alert user with on page text message send alert email to admin and add via API call comments to invocie payment failed
1. redirect users to a payment URL page after google form completion,. The URL is generated only after Googleform Completion and webhooks are sent to ZOHO Books/Flow with google form fields to automate payment link geeneration
2. Find a way to track conversion and source/campaign for analytics and google for my embedded Google Form on my website
No invoice creation required just API Calls/webhooks to send data to activate existing automation workflow from google form fields sent, and grab corresponding final created invoice payment link created by ZOHO to redirect user to pay immediately
1. After google form submission , create a page or pop up text to hold clients for 5-10 seconds during workflow (ie "Submitting Order", "Redirecting you to Payment Page")
2. Create backend form script to Send googlesheet fields on new row added via form payload to Webhook to ZOHO FLow to activate existing workflow which will create a payment link (ZOHO automation)
3-Find corresponding payment URL created from ZOHO, which was created after webhook. (matching order no field in Google sheet and ZOHO Books Invoice field)
4. Redirect users to the Payment URL immediately when available which may take 4-10 seconds on average
5. On payment completion (via checking Invoice status is paid) and show payment confirmed message and redirect back website + Send payload to facebook and google analytics for conversion to track source / campaign success
6. If failed, alert user with on page text message send alert email to admin and add via API call comments to invocie payment failed