Google Sheets input tool is failing in workflow execution

[EBhowmik]

Hi, 

I have configured a google sheets input tool which is failing multiple times with error in the Select/Filter tools where it is unable to find certain columns. e.g. Date column missing in Select tool

Conatct ID missing in Filter tool

but when I run them manually it is becoming successful. I would request to kindly suggest any work around to fix this kind of problem while using Google sheet input tool.

Thanks in advance.

[TrevorS]

Hello @EBhowmik 
Thank you for posting to the Community!
Can you please provide us with the full text of the error message? 

From looking at what your screenshot shows, the issue isn't with Google Input, but with the Contact ID data type you are trying to filter on.
Have you checked the tool # to make sure that the fields you are trying to filter on are present?

Without a copy of your workflow or the full error message, there isn't a lot that can be provided to you to troubleshoot.

Thanks!
TrevorS

[EBhowmik · Accepted solution]

@TrevorS

Thank you for the response. It was data type problem and now I have put Auto Field tool after the Google sheet input.

Thanks again