Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hello, I want my Zap to read a specific row from a google sheet and then insert the values into a google doc template.
My Zap is triggered by the customer number from a google forms. Then as Action I use Lookup Spreadsheet Row for google sheets. There I input for what column should be searched for. Here Zapier sees the column H, I, J, K and L.


But when I am in my next Action “Create Document from Template in Google Docs” it doesn’t show the option to take the value from column H-L and I can’t find out why, everything else is working and all columns and rows are filled till L. There is no spacing or empty column in betweeen or something like that .. 


Any help is much appreciated!

Hi @Namine 

Good question.

Check which GSheet Row (ID) was returned from testing to help you troubleshoot.

@Troy Tessalone Row ID 2, I think. And here at data out I can see that he actually does not only recognize the column but also the right data in the column.
 

 

@Namine 

You should now be able to map the dynamic variables between the Zap steps. (GSheets > GDocs)

@Troy Tessalone I'm experiencing the same issue but unsure what's the next step to fix it. Some context:

When a task is delivered to a client, Google Sheets will identify the right row by the task ID. It will run through a filter and if the '’Actual client delivery deadline'’ column is still empty in that specific row it will run.

 

However this '’actual client delivery deadline'’ column is column K and I am unable to select this in the filter

The lookup spreadsheet row does however identify Column K:

 

I am not sure what the issue is here and how to fix this one. Would you have any idea? ​​​​​​​

@MischaDR99 

In the Filter step, to select the variable from GSheets, try searching by the column header or the column letter or the column value.

 

@Troy Tessalone Thanks for your reply Troy. 

I tried all 3 but no luck:

 


 

 

@MischaDR99 

Make sure to test the GSheet step first before trying to configure the Filter step.

Hi @MischaDR99,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Hello,

 

I have the same issue. I can see all my column values (I am using through Column S) in Data Out, but only Columns A-G show up as variables able to use. Any ideas?

Hello,

 

I have the same issue. I can see all my column values (I am using through Column S) in Data Out, but only Columns A-G show up as variables able to use. Any ideas?

Hi there, 

I think what solved the issue for me was setting up a new zap. In that way the most up-to-date was automatically synchronized and I was able to select all columns.

I had like a 5-step zap so it wasn't too hard to set up again. Not sure how big yours is.

Hope this helps

It worked for me when I added data into at least one of the cells in the column. when all of the cells in the column were blank, the whole column wasn’t showing up in the sheets output.

That’s awesome ​@automatan! Thank you for sharing the solution here this is going to be helpful to our other Community members who’s running into the same issue here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Reply


Terms & Conditions