Integration with Google sheets

Hello @Liz 
As for what I see, I feel the headers might have been formatted with text-wrapping to go onto another line (I assume for them to be readable) - I am saying this based on the fact so far all docs synced with Typeform I’ve seen have headers in overflow and this one differs. Could it be the cause?
In case it is, what should we do? Would it be a matter of re-doing the connection, importing all responses onto a brand new worksheet? If so, is it enough to turn the toggle off and then back on, setting a new file on Google and importing all responses in there?
The document per se is spilling the raw data onto another tab called ‘consolidated’ that basically returns the data in a more user-friendly way and does some calculations on top of it.
We already had some issues with the 2 tabs no syncing properly and the need of manually extending formulas at regular intervals. That got somehow fixed by setting up reminders and changing the refresh time for the document within settings.
Do let me know your thoughts on this :)
Many thanks for your help!
E.

@Elisa Reinaudo - from a user here.. 

are you using the arrayformula function and vlookups on the google sheets - as opposed to copying formulas down the columns??> 

this was an error that i was making initially as i was trying to add data into a reporting tab on google sheets - by using the above mentioned functions, along with some if() statements, i was able to eliminate that problem.

I also got around the long field names by ensuring that created a second tab of every google sheet integration where i renamed the column headers ‘more logically’ for me (ie q1a, q1b, q2a, etc...) and using that in the reporting.. I leverage a google addin called Document Studio as well… jic. 

cheers

des

@MCSims - if i said brute force, meaning manual entry for the column headers 

I have provided two images below - the first of the typeform entry tab, one cell highlighted to show that the question is long (as they are all long and make no sense looking at the whole thing (as you know). I have also shown the array of tabs that have for this sheet to show you the reporting tab, where i pull in data from a the other tabs to add value to the report that is autogenerated and mailed out to the respondent 

here’s the first image - click it to expand so that you can read it lol

Note the first column is question where i ask them to select an industry sector from the list if they want to get comparative data for that sector in the report (you will see an industry tab there as well that has the data i pull into the reporting tab based on the user input)

The second image is from the reporting tab, and show the custom column/field names that used - yes manually entered and, in this case, they correspond to question groups and the questions inside that group. You will also note that the text ‘answers’ for the questions are converted to a numeric result on the reporting tab so that i can do a bunch of rating calculations. The arrayformula() for the conversion of the text string/answers is shown based on the cell highlighted - just to give you an idea of how i use that function to auto-populate the rows into the reporting tab based on new entries arriving in the main tab. 

all the formulas for getting the data and converting it into something useable (for my purposes) are driven off the first column and this is the formula in A2 =arrayformula('Data Governance - Quick'!A2:A)

so you can change the tab name from what you see to your own if that works for you. 

hope this gets you one step further. 

des

@MCSims - there are some things to watch for that include new/deleted fields in your typeform.

what i have seen to date (at least for my forms) is that when i add a question, and publish, the field is updated at the end/far right of the connected google sheet. then all i have to do is map it into the structure of the reporting tab and update any outputs, transforms etc - it all depends on what you are doing with that new data in anything pre-existing. 

sometimes i have had to turn off the integration and create the google sheet  again - i will typically give it a new name ie sheetname_2 - then i will copy additional tabs from the existing data set and make any adjustments to the reporting tab headers 

after you go through the process a couple of times, it doesn’t take more than a medium coffee to replicate and update the tabs. 

autogenerating new column headers for reporting tab in this fashion would require some work with data-dictionary concepts and some advanced macros to map survey question text to input header location and then to the appropriate short names and the order you want them presented in the second tab. It could be done but i don’t have the mind space to work on that before i retire lol. 

(and i really don’t want to have to troubleshoot the typos in creating the arrayformula lookups with a 30 word question as the comparator. call me lazy lol)

Hello everyone!
Glad you guys took the time to tackle the issue and I am also happy to see so many responses in here.
My main issue was (and actually is on another project) I was seeing a number of answers on typeform results and that was not reflected within the Google sheet I had as per integration set up.
On the project I was referring to in this thread, the cause could definitely have been somebody formatting the sheet on the page they were not supposed to but on the project I am currently running, I still have the issue but nobody has put their hands.
So I do see 2,290 answers on Typeform and 2265 on Google Sheets.
What could the reason be?
Thanks
 

@Liz  I had the same issue on 2 projects.
First one had been edited so you know, you were 100% right :)
Second one...the numbers do not coincide, the survey is over and the file has not been touched!
Not sure what to think.

Hello @john.desborough  and @Liz 
Always adding to this thread, I’ve noticed some unexpected blanks (empty cells) despite some fields being mandatory.
(Neither the same survey nor a file that had been manipulated - recalling what you guys initially told me I’ve never ever touched anything again on any connected spreadsheet - I am now always referring back to the spreadsheet and manipulating it on another file).
I need to do some calculations over these data and those blanks make no sense and might skew the interpretation.
Would you mind helping me with this, please?
Thanks