I am using Google Sheets to display data in my WordPress table. I found this code to call single cell data as simple text, but the problem is it's requesting multiple times to google sheet URL so the page size and load time are too long
How can we cache the google sheet URL for 2 hours so the page can make lower requests?
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 1" class="no-datatables"] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 1" class="no-datatables" ] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 2" class="no-datatables" ] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 2" class="no-datatables" ] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 3" class="no-datatables" ] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 3" class="no-datatables" ] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 4" class="no-datatables"] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 4" class="no-datatables" ] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 5" class="no-datatables"] [/tt]
[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 5" class="no-datatables" ] [/tt]
