Help Needed: Dynamic Column Creation and Cell Update in Google Sheets

Discussions
1

Hi folk,

I’m seeking assistance with a couple of tasks related to Google Sheets for our internal MIS system. Here’s what I need help with:

  1. Dynamic Column Creation with Today’s Date:
  • I need to add a new column daily with a custom value, specifically today’s date.
  • The column should be created only if it doesn’t already exist.
  • An edge case to consider is when the range might exceed the grid limits. How can I handle this efficiently?
  1. Dynamic Cell Update:
  • I want to update specific cells dynamically by passing cell addresses like E12, etc.
  • I initially thought about using the row update action, but it seems to require mapping prior key-value pairs, which limits dynamic updates.
  • I’m open to using the Google Sheets custom API, but I’m unsure how to implement this effectively.

Any loom or snapshot, examples, or step-by-step instructions would be incredibly helpful.

Thanks in advance for your support!