Title: change cell value in shortcode automatically.
Last modified: March 21, 2018

---

# change cell value in shortcode automatically.

 *  [lakshya007](https://wordpress.org/support/users/lakshya007/)
 * (@lakshya007)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/change-cell-value-in-shortcode-automatically/)
 * [Google sheet for reference](https://docs.google.com/spreadsheets/d/1DjHekC9xQS5qe6SDbNRYuKxEb30N-_41OStKCNI3OB0/edit#gid=929095845)
 * I have google sheet linked to a google form. Whenever the form is submitted there
   is a new row added to the google sheet. I want this data to be displayed on my
   WordPress site automatically.
    Can I run a query so that the value of the cell
   property is taken at runtime so that it selects whichever cell was last modified
   or has the latest timestamp?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fchange-cell-value-in-shortcode-automatically%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

The topic ‘change cell value in shortcode automatically.’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/dans-gsheets.svg)
 * [Dan's GSheets Data Embedder](https://wordpress.org/plugins/dans-gsheets/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/dans-gsheets/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/dans-gsheets/)
 * [Active Topics](https://wordpress.org/support/plugin/dans-gsheets/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/dans-gsheets/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/dans-gsheets/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [lakshya007](https://wordpress.org/support/users/lakshya007/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/change-cell-value-in-shortcode-automatically/)
 * Status: not resolved