“Your table is empty” using Google Sheet

  • Resolved Candace

    (@aunrea)


    3 months, 1 week ago

    I have connected Google sheets correctly and can see my files, but when I select the one I use I get “Your table is empty.” The table has data. I even uploaded the example file and selected that one and I get the same results. It has been over 2 hours since I set up the google connection.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Jasmine

    (@hyenokian)

    Dear @aunrea,

    Thank you for the topic.

    Most presumably, the Google Sheets API is disabled.
    So, please head to the following link with the account to which you are connected:
    https://console.cloud.google.com/apis/library/sheets.googleapis.com

    There, check whether the API is enabled or not.
    If not, please enable it, wait for some minutes, and check whether the issue has?been resolved or not.

    See the screenshot below:

    View post on imgur.com

    Please check this and get back to us with an outcome.

    Thank you.

    Thread Starter Candace

    (@aunrea)

    I saw enable drive in the instructions, but not enable sheets.

    Also how do I get dates to show up as dates and not large decimal numbers?

    Plugin Support Jasmine

    (@hyenokian)

    Dear @aunrea,

    Thank you for your response.

    Please let us know what steps you have taken more in detail as I am not sure I understand your request correctly.
    Please let us know whether you managed to find and enable the API?or not.

    As to the following part:
    <<Also how do I get dates to show up as dates and not large decimal numbers?

    I am not sure I understand your question correctly
    So, please clarify your request so that we can guide you accordingly as soon as possible.

    Thank you.

    Thread Starter Candace

    (@aunrea)

    I did get the sheets enabled and it works.

    The dates are messed up. They are formatted like 8/15/2024.

    Thread Starter Candace

    (@aunrea)

    Is there a way to only use some columns of a google sheet? I don’t want all the columns used on another chart.

    Plugin Support Jasmine

    (@hyenokian)

    Dear @aunrea,

    Thank you for your response.

    I want to mention, that your data must be of either the Text or Number type for this chart.?
    Most presumably, your data is of the Date type, due to which, the casting is done automatically and the plugin gets the cast number from Google.

    So, we would recommend you change the data type to text and check the case again.

    See the screenshot below:

    View post on imgur.com

    As to the following part:
    <<Is there a way to only use some columns of a google sheet? I don’t want all the columns used on another chart.

    I want to mention, that the plugin allows choosing the columns you want/don’t want to use.

    See the screenshots below:

    View post on imgur.com
    View post on imgur.com

    Please check this and let us know about the outcome.

    Thank you.

    Thread Starter Candace

    (@aunrea)

    I have the dates showing correctly. I did see the columns button and clicked it. I can’t select any of the checkboxes. None are selected and they can’t be selected.

    Plugin Support Jasmine

    (@hyenokian)

    Dear @aunrea,

    Thank you for your response.

    I want to mention, that our Dev Team needs more information for further investigation of the case.
    So, please contact us via this form for further discussion and investigation of the case. Our customer care specialists are ready to check the case and give a solution accordingly as soon as possible.

    Thank you.

    Plugin Support Jasmine

    (@hyenokian)

    For other readers, we are closing the ticket as the customer contacted us via email, we found the reason for the problem and guided how to solve the problem accordingly.

    Thank you.

Viewing 9 replies - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.