Streaming live at 10am (PST)

Export Webflow Forms into SUPEMETRICS Excel/Sheets


#1

Who here has success doing Daily refresh of SUPERMETRICS using webflow io forms?

I’m building dashboard with the following

  1. AdWords daily refresh - > Conversions from 01/01/2017
  2. Salesforce daily - > ‘New’ leads Daily refresh from 01/01/2017
  3. 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.


#2

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


#3

@Jinglebell

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.


#4

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