Forum Discussion

mpalha04's avatar
mpalha04
Helper III
8 years ago

Errors when Refreshing Google Sheets Data

I have successfully connected to my Google Sheets data using the Web connector, however, when I hit the refresh button multiple errors show (table not found, etc.). Sometimes it refreshes nicely, sometimes that error message shows, but it's not completly reliable. Does anyone know how to resolve this issue to have Google Sheets data refreshed seamlessly.

 

Thanks

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    mpalha04,

    Could you please post the error message that you get?

    Regards,
    Lydia

    • mpalha04's avatar
      mpalha04
      Helper III
      8 years ago

      Here is the error message that shows when I hit Refresh

      • mpalha04's avatar
        mpalha04
        Helper III
        8 years ago

        I should mention that nothing has changed in my table. Sometimes the data refreshes properly, sometimes I get this message.

  • andreilupan's avatar
    andreilupan
    Regular Visitor
    6 years ago

    It seems that this issue wasn't fixed. I have exactly the same issue here. In 60-70% of the cases when the query is refreshed, an error pops up saying that "The column XYZ of the table wasn't found." When I refresh it again, a different column appears to not be found. This is not a data source issue, because all the columns are intact in the table I'm pulling the data from. And it's not a code syntax issue, because even though the Applied Steps remain exactly the same, sometimes the data is pulled correctly and sometimes it is not.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    The same problem! Completely as you describe - in some cases data from sheets are updated very easy, in some cases the issue "Column not found". But nothing change. I thought that opened sheets are not updated but not :(. It is really a problem with Google sheet updating.