Daily Reading of Google Sheets Cell Content Made Easy

Problem: Reading the content of a cell from a Google Sheet every day

One of our users recently asked a question about reading the content of a cell from a Google Sheet every day. They wanted to read a different row based on the day of the week, for example, on day 1 they wanted to read row 1, on day 2 they wanted to read row 2, and so on.

Solution: Using the Get a Cell module and formatDate function

The solution to this problem is quite simple. In the "Get a Cell" module of Google Sheets, you can use "A" plus the formatDate function with the format "d" to get the day of the week from 0-6, where 0=Sunday. Then, you'll need to add 1 because your rows start from 1. For that, you can use the sum function.

Here's a screenshot of how it looks:

And here's the output:

Additional Question: Retrieving the week of the year

Our user also asked how to use the formatDate function to retrieve the week of the year, similar to the WEEKNUM() function in Excel. According to the Tokens you can use to format a date variable, you can use "w" or "ww". For example: formatDate({{now}};w).

Conclusion

Reading the content of a cell from a Google Sheet based on the day or week of the year is quite simple with the "Get a Cell" module and the formatDate function. Remember to add 1 to the result if your rows start from 1. And if you want to retrieve the week of the year, you can use "w" or "ww" in the formatDate function.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.