I got daily counters working from flic to google sheets by keeping one sheet that adds a new row with the timestamp a flic button is pressed (via. IFTTT) and another sheet that counts the number of rows on the first sheet that match a given day.

Here's what the first sheet () looks like:

Here's what the second sheet looks like:

The formula I use in the second sheet is:

=COUNTIFS(Sheet1!A:A, ">="&A2, Sheet1!A:A, "<"&A3)