Google Sheets

  • Resolved itgoab

    (@itgoab)


    2 years, 10 months ago

    Just thinking about upgrading to Premium Tablepress. But I’d like to be able to link a Google Sheet with a WordPress Table. I see you can do that with an Excel sheet using Automatic Periodic Table Import. But will it work with a Google Sheet?
    Also, how often can you set the sync to run? Does it do it to a schedule or do you have to run an manual sync?

    Thank you.

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    2 years, 10 months ago

    Hi,

    thanks for your question!

    Yes, Google Sheets can also be used with the Automatic Periodic Table Import feature. Essentially, you will just have to use the public CSV sharing URL that you can get from the “Share” feature in Google Sheets. Then, you would just use that URL as the Import source and TablePress would get the data from that Google Sheet.

    The periodic import runs on a periodic schedule, like “every 15 minutes”. This will not be 11:15, 11:30, 11:45, etc. but start whenever the configuration is saved. It might also sometimes be 15 minutes and a few seconds, due to how the underlying WordPress Cron system that is used for this, works. (For more reliability, a server cron job can help, which most hosting packages nowadays offer.) The smallest interval that TablePress brings with it is 15 minutes, but this can be lowered with a bit of custom code. I don’t really recommend going below 5 minutes or so, due to the extra HTTP requests that are made by this, but something like 2 minutes should also still work.

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Google Sheets’ is closed to new replies.