WRITE BACK TO GOOGLE SHEETS FROM TABLEAU | @josh_tapley

Write Back to Google Sheets from Tableau | @josh_tapley

Are you ready to build some Google Sheets write-back directly from Tableau in just a few easy steps?

google_forms_7

Well then, read on…
___________________________________________________________________________

Tech savvy? Skip to the end and here is the URL that you are looking for.

https://docs.google.com/forms/d/e/1FAIpQLScvBRmtsC4kjAa5z9mxwp_Q4Kv4RlIH_xORQs-L9ZSIes85LQ/formresponse?entry.1899794355=123&entry.1464131260=Sample+annotation&submit=Submit

Start with a Google Form pre-popluated link.  Use the ‘formresponse’ protocol and add ‘&submit=Submit‘ to the end of the URL.

If that makes no sense, then keep reading for the easy step-by-step instructions.

To get started we need both a Google Sheet created and a Google Form. The easiest way I found to get started was to begin with a new sheet.

google_forms_1

Once you have the sheet, use the ‘Tools > Create a form’ menu to add a new form.

google_forms_2

Name your new form and create your core questions. Make sure to set

Read more…

Write Back to Google Sheets from Tableau

Are you ready to build some Google Sheets write-back directly from Tableau in just a few easy steps? Well then, read on… ___________________________________________________________________________ Tech savvy? Skip to the end and here is the URL that you are looking for. https://docs.google.com/forms/d/e/1FAIpQLScvBRmtsC4kjAa5z9mxwp_Q4Kv4RlIH_xORQs-L9ZSIes85LQ/ formresponse?entry.1899794355=123&entry.1464131260=Sample+annotation&submit=Submit Start with a Google Form pre-popluated link.

 

The following two tabs change content below.

Eric Axelrod

President & Chief Architect at DIGR
I have helped companies bring new data driven products to market, drive efficiency out of their supply chain, execute strategic plans, and drive top line and bottom line growth by enabling every business function with actionable analytics. I can transform a business which is lacking critical insight into an agile, strategic, data driven organization.

One thought on “WRITE BACK TO GOOGLE SHEETS FROM TABLEAU | @josh_tapley

  1. joshtapley Reply

    Thank you for featuring my blog! If you decide to embed a form in your dashboard, you can use the same logic to pre-populate values based on your selection.

Leave a Reply