gsheets | Get public Google Sheets as plain JavaScript/JSON | JSON Processing library

I'm absolutely not a dev or anything but I'm searching everywhere to make this work.

I run a swim club and I'd like the members to have a cool app to check everything about the organization. Events, calendar, best times,.. I'm currently building it with Glide and therefore I'm using GSheets as a database.

Trying to automate things a little bit, I've already managed that for every swimmer registering on the app, it creates a new line in my master worksheet with the name of the swimmer and the link to his profile on a swimming data bank website. When my script is executed, a new worksheet is created and the row with the name and the link are also appended to the right worksheet.

Well, I have two problems now.

1. I'd like to push an importhtml formula in a 3rd column
2. I'd also like that the row with the name and link in every worksheet doesn't duplicate each time the script is executed.

Running into an issue with the W2UI grid.

Goal: I'd like to be able to select an entire column and copy/paste it to Gsheets. Alternately I'd like to be able to click a single cell and copy it's contents too.

Issue: When clicking it selects the entire row including all irrelevant columns, and copying that includes headers too, meaning it has to be cleaned manually before it can be inserted into a spreadsheet.

The "editable" property allows me to select a single cells contents but even that's not quite what I'm looking for as it required 2 clicks, highlighting text then copying, adding 3-4 button presses to the process.

Can't seem to find the answer on how to fix this in the documentation but I may just be missing something.

I has setup flutter project get data from my Google sheet ,use Package gsheets 0.2.6 to get data when I get data use the print to check DateTime , I can verify is correct date time like this "2021-03-11 13:41:05" but when used the

I am trying to get Gsheets to send to multiple emails. It is gathering information from A2 & A3 only. How do I fix this?

I have a sheet with daily readings of lake level and temperature. I want to extract the max level for each day of the year, along with the year that the reading occurred. If it occurred more than once on the same day of the year, I'd like the first occurrence. It's easy enough to get the max for each day, but I haven't been able to also extract the year. I'm sure there are other people much more versed in GSheets than me who can figure this out. I also expect it's not that difficult, but I've yet to be able to find something that works.

Here's the sheet: https://docs.google.com/spreadsheets/d/1kC3L0oDpnnJlFFuB76mUXiz3vGcfT5_fC3YbkE9Xgsg

I'm working on a python script to grab some data from ESPN and update a google sheet. Specifically I'm pulling the spreads and over/user for the 4 NFL playoff games this week.

I'm able to successfully scrape the data I need and print it to console. But although I'm able to successfully update a Google Sheets cell with dummy text "Testing", when I try to update the cell with text from the web element, it throws an error.

In google sheets when I insert a date it saves it in the right format when I get that value I get an int number I insert this 1/6/2021 & I get that 44202 1/6/2021 => 44202 how to convert this number to date in dart or java or any language

I get it from google sheets API using a package so it gives me a number

https://pub.dev/packages/gsheets

Context

In google app script for gsheets I am running this function that searches the names of items in a comma separated list within a single cell per row, against a list of item name and ids in 2 columns.

The function is called within another function that iterates through each row of data in the Data Table.

The goal is to replace the names with the ids in a comma separated list.

The Problem

The nested loop just doesn't run! When I set up training outputs to test where the code gets blocked it's at the inner for loop, it breaks at that line and doesn't execute at all. I cannot figure out why that would be as I can't see a problem with my syntax.

Any ideas where I could be going wrong please?

The data looks like this:

As a follow-up to the question I posted previously here - Excel/GSheets count unique versus reoccuring values in dynamic list I am looking to count unique values in a list of 30k+ Webinar attendees, but this time across multiple criteria.

The logic here is a bit different than a simple COUNTIFS formula as I need to retain all the rows to visualize and interact with in Google Data Studio - so in other words, I need a formula to insert a unique flag ("New" or "Returning") based on the uniqueness parameter.

In short, I need to add logic to this formula to consider different uniqueness:

=IF(COUNTIF($B$2:$B2,B2)>1,"Returning","New")

Let's use this simplified data set example for me to explain, notice all attendees are unique except P1 and notice how the values in columns F and G should change by the criteria. Note, I've added borders and colors for easier comprehension.

Link to sample data - https://drive.google.com/file/d/1LxirDbk-9w5zu5qqFNoBI9QiK4Za6lFA/view?usp=sharing

Here's the graph the data is going in:

Any help would be much appreciated! Thank you!