About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

GSuite New Quote Request workflow

  • 9 March 2021
  • 3 replies
  • 14 views
A

I have a complex Estimation s Spreadsheet in Google sheets.  * indicates steps that I am stuck on.

  1. I Created Google form to act as data capture for New Quote Requests
  2. Made a Zap that Creates a new Folder name based on the estimate #  in my form response spreadsheet  
  3. *I need to input the entire line of data from the Form Submission into my Estimate Spreadsheet Template (Sheet 1 row 3 ) but it keeps posting all of the information into Cell A3 rather than into each individual cell in row 3
  4. My Zap then Creates a Copy of my estimate template and re names it  based on the Job #
  5. *I want this New Estimate spreadsheet to save into the new folder I created in step 2
  6. *I want to have a sub folder that is created in each new folder from step 2

If anyone has any input on steps 3,5,6 it would be greatly appreciated

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Nate
Userlevel 5
Badge +6

@Aspen Jam would you be able to share some screenshots or screen-recording of your current setup so we can better troubleshoot? 

Nathan Weill - Flow Digital
SamB
Rank
Userlevel 7
Badge +11

Hey @Aspen Jam, 

Usually with Google Forms, each answer comes through in a separate field that can be selected for the different cells on the spreadsheet row. But if you’re looking to split up text contained within a single answer field then you might need a Formatter (Text > Split Text) action to split the information out into separate fields. You can find out more about how to do that here: Modify text formats in Zaps

To have the new estimate spreadsheet added into the folder that the Zap creates, you’d want to use the Move File action for Google Drive. This should allow you to specify the folder using the ID (using the Custom value option) that’s given by the Create Folder Google Drive step.

To add a sub folder within the new folder, you’ll want to select the folder ID from the previous Create Folder step for the Parent Folder field.

Hope that helps. If you run into any issues on that, please let us know. We’re here to help!

Paolo
Userlevel 3
Badge +5

Hi @Aspen Jam, to double-check, did the previous suggestion help with your question?

Terms & Conditions