Who here has success doing Daily refresh of SUPERMETRICS using webflow io forms?
I’m building dashboard with the following
- AdWords daily refresh - > Conversions from 01/01/2017
- Salesforce daily - > ‘New’ leads Daily refresh from 01/01/2017
- Webflow Forms - > New form entries from 01/01/2017
1 and 2 are completed. 3 I am struggling with.
I need to be able to easily validate Webflow forms against salesforce and AdWords, particularly for duplicates vs uniques.
How are you getting the form data into your Google Sheet? Using the Zapier integration?
And then for finding duplicates against other data, that’s a function you need to run in Google Sheets. See this here: https://www.youtube.com/watch?v=skQEKi0zULg
As of now its only adding new 1on 1 entries. I use daily refresh on Google Sheets and Excel. What I need is to daily dump the whole forms file from webflow the same way as Salesforce and AdWOrds, not 1on1 get/post by means of SuperMetrics. Zapier only allows for single entries, but does not allow for daily dumps.
My current workaround is having them download csv into a sheet that is =importrange() back into main, though this is a manual process.
Ok I get what you’re trying to do. You need a tool that can process a batch of data in one single action.
Look into this help article here, she explains how to send a CSV file to an email, then Zapier collects the csv in attachment and finally creates rows in Google Sheets: https://help.gocanvas.com/hc/en-us/community/posts/360002727113-csv-to-zapier-to-google-sheets