Title: Content Import
Last modified: February 15, 2021

---

# Content Import

 *  Resolved [jakerunyon](https://wordpress.org/support/users/jakerunyon/)
 * (@jakerunyon)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/content-import/)
 * Hello, I am trying to use this shortcode to embed a google sheets API. The API
   is as follows:
 * [https://sheets.googleapis.com/v4/spreadsheets/191PzqpXOJmmQcHO5Z_esIKUr26I2_U5-qQny3Wppysw/values/B9?key=AIzaSyDOuWsuSld94N8XuHZwMJ4fS59CpO98vOg](https://sheets.googleapis.com/v4/spreadsheets/191PzqpXOJmmQcHO5Z_esIKUr26I2_U5-qQny3Wppysw/values/B9?key=AIzaSyDOuWsuSld94N8XuHZwMJ4fS59CpO98vOg)
 * Is there anyway you could help me figure out how to get the “values” to display.
   It shows nothing instead of what I want it to say: 6419510

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [jakerunyon](https://wordpress.org/support/users/jakerunyon/)
 * (@jakerunyon)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/content-import/#post-14049453)
 * This key is not valuable at all as it’s a public document anyways.
 *  Plugin Author [berkux](https://wordpress.org/support/users/berkux/)
 * (@berkux)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/content-import/#post-14050151)
 * Hi,
 * unfortunately the free JSON parser can’t handle this. Sorry.
 * Bernhard
 *  Thread Starter [jakerunyon](https://wordpress.org/support/users/jakerunyon/)
 * (@jakerunyon)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/content-import/#post-14051733)
 * Can the paid JSON parser handle this?
 *  Plugin Author [berkux](https://wordpress.org/support/users/berkux/)
 * (@berkux)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/content-import/#post-14058284)
 * Ask any question about the pro plugin at
    [https://jsoncontentimporter.freshdesk.com/widgets/feedback_widget/new?searchArea=no](https://jsoncontentimporter.freshdesk.com/widgets/feedback_widget/new?searchArea=no)
   please.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Content Import’ is closed to new replies.

 * ![](https://ps.w.org/json-content-importer/assets/icon-256x256.png?rev=3464653)
 * [Get Use APIs - JSON Content Importer](https://wordpress.org/plugins/json-content-importer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/json-content-importer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/json-content-importer/)
 * [Active Topics](https://wordpress.org/support/plugin/json-content-importer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/json-content-importer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/json-content-importer/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [berkux](https://wordpress.org/support/users/berkux/)
 * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/content-import/#post-14058284)
 * Status: resolved