Import a cell?

Return row 1, column A (cell A1):

[gdoc key="ABCDEFG" query="select A limit 1"]

Return row 5, column 3 (cell C5):

[gdoc key="ABCDEFG" query="select C limit 1 offset 4"]

However, in practice you probably want to restructure your spreadsheet or your query if you just want to return a single value. For example:

Pre-processing data with Google Queries

You can pre-process your Google Spreadsheets or CSV files before retrieving data from them by passing a Google Charts API Query Language query to the shortcode’s query attribute. This lets you interact with the data in your Google Spreadsheet or CSV file as though it were a relational database table. For instance, if you wish to display the team that scored the most goals on your website, you might use a shortcode like this to query your Google Spreadsheet and display the highest-scoring team, where the team name is the first column (column A) and that team’s score is the second column (column B):

[gdoc key="ABCDEFG" query="select A where max(B)"]

It worked but still displaying the header of the selected column.

Use strip="1" to strip the column headers.

[gdoc key="ABCDEFG" strip="1" query="select A limit 1"]