stevesny Posted November 9, 2019 Share Posted November 9, 2019 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? Beyondspace 1 Link to comment
joelygoe Posted December 19, 2020 Share Posted December 19, 2020 Same Question Beyondspace 1 Link to comment
Beyondspace Posted December 20, 2020 Share Posted December 20, 2020 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 blackdirtbeauty 1 BeyondSpace - Squarespace Website Developer 🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox) 🗓️ Delivery Date Picker (Squarespace Date format) 💫 Animated Buttons (Referral URL) 🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations) 🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates) If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you! Link to comment
joelygoe Posted December 21, 2020 Share Posted December 21, 2020 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
brownieontherun Posted March 23, 2021 Share Posted March 23, 2021 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! Beyondspace 1 Link to comment
Beyondspace Posted March 23, 2021 Share Posted March 23, 2021 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! That's good trick to create shortcut like that! BeyondSpace - Squarespace Website Developer 🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox) 🗓️ Delivery Date Picker (Squarespace Date format) 💫 Animated Buttons (Referral URL) 🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations) 🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates) If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you! Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment