2nd Google sheet integration | Community
Skip to main content
Question

2nd Google sheet integration

  • October 15, 2024
  • 4 replies
  • 32 views

Hello,

Is it possible to integrate a second google spreadsheet or work sheet tab?

Basically I need an exact copy of the original integration so that i can make additional columns to it, but keeping the original integration as is.

It's important that the rows are added to both sheets each time an entry is completed on the typeform.

TIA

4 replies

Forum|alt.badge.img+4
  • Socializer
  • 113 replies
  • October 15, 2024

Hi @DrankFrames ,

You could use something like Make or Zapier (or just use the GoogleSheets API directly if you are up to it) to keep the 2 GoogleSheets in sync.

 


  • Navigating the Land
  • 2 replies
  • October 29, 2024

I need an exact copy of the original integration so I can add extra columns, but I want to keep the original integration intact.


Forum|alt.badge.img+4
  • Socializer
  • 113 replies
  • October 29, 2024

Hi @matrio ,

You could setup the Make (or Zapier) integration so that the original sheet is intact.


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5316 replies
  • October 29, 2024

@matrio - are these additional columns outside of the typeform response (ie calculated fields or some such nonsense lol)? if they are, you can create an additional tab and then use the google sheet arrayformula() function to pull the data from the primary tab into this new one 

 

that approach will bring the data in the original columns across and then you can add the additional columns that you want. 

 

just a thought - i do this all the time for reporting 

des


Reply