Jump to content

Can Form submissions connect to Google Sheets in sub directories on Drive?

Recommended Posts

Is there a way to send Form information to a Google Sheet if the Sheet has been moved to a subfolder on Google Drive?  I have set up a couple FORMS to send submission information to Google Sheets on his DRive. ( all worked fine...) But he moved those ( working) Sheets into new subfolders on his Google Drive and the Form submissions are no longer connecting to the Sheets.  Do all Google Sheets capturing Squarespace Form information have to remain on the ROOT of the Drive?  Does anyone know how to redirect the FORM submissions to their assigned Sheets in a subfolder?

Link to comment
  • 1 year later...

I think squarespace does not support that on default, you may have to use some automation to clone the content in root folder to the new spreadsheet, like Zapier or Google Apps script

Another idea is to take advantage of Zapier submission and transfer the data on new sheet via Zapier

Greeting, it's BeyondSpace, I am Squarespace dev focus on provide solutions to enhance feature that squarespace.com can't provide.
Feel free to check my current Squarespace Plugins Developement: Enable Pinch/Zoom on lightbox, Delivery Date Picker, Keyword Highlighter
If you find my answer fit your need, let's leave a like or upvote so others with the same issue can find their solution. Thank you

Link to comment

Hey @bangank36 thanks for clarification.  I'll look into Zapier but have actually started using mailchimp so may use that.  So many apps/third-party solutions (Google, Squarespace, Mailachimp, Asana a etc etc!  Sounds like Zapier may help with all this.

 

@stevesny I just have the email come to me as I don't get that many enquiries anyway that the moment to warrant triaging them all.  Once I start advertising and scaling up my paid media I might but for now I am just starting with my Earned and Owned network.

 

Joe

 

 

 

Link to comment
  • 3 months later...
3 minutes ago, brownieontherun said:

Hi @stevesny

So I found a solution to this! If you create the file from the Google Sheets home screen, you can add a shortcut to the file in a chosen drive folder. You can do this by going to 'File' then choosing 'Add shortcut to Drive'. This worked for me! 

Screenshot 2021-03-23 at 16.24.07.png

That's good trick to create shortcut like that!

Greeting, it's BeyondSpace, I am Squarespace dev focus on provide solutions to enhance feature that squarespace.com can't provide.
Feel free to check my current Squarespace Plugins Developement: Enable Pinch/Zoom on lightbox, Delivery Date Picker, Keyword Highlighter
If you find my answer fit your need, let's leave a like or upvote so others with the same issue can find their solution. Thank you

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.