Utilizing setInterval to navigate through a Google Sheets document

Question

Utilizing setInterval to navigate through a Google Sheets document

I have a Google spreadsheet with 4 rows, and I want to iterate through them one at a time every hour. The current code works but posts all four rows at the same time. How can I post one row every hour continuously?

require('console-stamp')(console, {
    pattern: 'dd/mm/yyyy HH:MM:ss.l'
});

var Twit = require('twit');
var config = require('./dmconfig');
var Tabletop = require('tabletop');

var bot = new Twit(config);
var spreadsheetUrl = 'https://docs.google.com/spreadsheets/d/1234567/edit?usp=sharing';

var link = () => {
    Tabletop.init({
        key: spreadsheetUrl,
        callback(data, tabletop) {
            data.forEach(d => {
                var status = d.tweetMsg + ' ' + Math.floor(Math.random() * 10000) + ' ' + d.userURL + ' via @AlDerbyshireG';
                console.log(status)
                bot.post('statuses/update', {
                    status
                },
                (err, response, data) => {
                    if (err) { console.log(err) }
                    else { console.log('Post success!') }
                });
            });
        },
        simpleSheet: true
    });
}

link()
setInterval(link, 1000 * 60 * 60)

javascript setinterval google-sheets-api tabletop.js

Answer 1

Answer №1

According to the TableTop documentation found in the repository's readme, setting simpleSheet: true will provide your callback function with an array of rows from the first sheet of the workbook.

Here is the sample code:

callback: (data, tabletop) => {
  data.forEach(d =>

This code processes every row on that particular sheet.

If you only want to call a function for a single row each time the callback is executed, you need to create another variable within the scope - let's name it rowIndex. This variable should be initialized when your bot server loads and then updated and checked against limits within the callback.

var rowIndex = 0;

var link = () => {
    Tabletop.init({
        key: spreadsheetUrl,
        callback(data, tabletop) {
            if (!data.length) { return; } // Ensure the spreadsheet isn't empty
            // Account for added or removed messages since last action.
            rowIndex = rowIndex % data.length;
            var d = data[rowIndex];
            /**
             * Code to execute for this specific row `d`
             */
            // Update the state variable for future calls to target different rows.
            ++rowIndex;
        }, // End definition of callback
        simpleSheet: true
   });
};

Answer 2

According to the TableTop documentation found in the repository's readme, setting simpleSheet: true will provide your callback function with an array of rows from the first sheet of the workbook.

Here is the sample code:

callback: (data, tabletop) => {
  data.forEach(d =>

This code processes every row on that particular sheet.

If you only want to call a function for a single row each time the callback is executed, you need to create another variable within the scope - let's name it rowIndex. This variable should be initialized when your bot server loads and then updated and checked against limits within the callback.

var rowIndex = 0;

var link = () => {
    Tabletop.init({
        key: spreadsheetUrl,
        callback(data, tabletop) {
            if (!data.length) { return; } // Ensure the spreadsheet isn't empty
            // Account for added or removed messages since last action.
            rowIndex = rowIndex % data.length;
            var d = data[rowIndex];
            /**
             * Code to execute for this specific row `d`
             */
            // Update the state variable for future calls to target different rows.
            ++rowIndex;
        }, // End definition of callback
        simpleSheet: true
   });
};

Utilizing setInterval to navigate through a Google Sheets document

Answer №1

Similar questions

Introducing the innovative Icon Collapsable JQuery - a versatile tool that

Adding content to an Element Id using JavaScript can be done by utilizing the .insertAfter or .append methods. Since it involves a script tag, you cannot use the dollar sign

The ElementNotVisibleException error was triggered because the element is currently hidden from view, making it unable to be interacted with through the command

Tips for adding a "dynamic" backdrop in THREE.js

Integrating secondary functionality into fullPage and Vue.js

Access the data within a jsonArray using Cypress

Postman encountered a preflight failure on the Node API request

Ways to retrieve the identifier of the uploaded document in GridFs for linking with another model

Achieving this result in HTML using a jQuery accordion component

The Bootstrap modal is not properly clearing all attribute properties when it is hidden

What is the best way to utilize the react hook useEffect just once in my scenario?

Dynamic fade effect with GSAP on scroll

Building a straightforward expandable/collapsible tree view with AngularJS by utilizing a particular data format

Error: The function m.easing[this.easing] is not defined

The onfocus event in Chrome's JavaScript add-on fails to trigger

html5-jquery checkbox change event not firing

What is the best way to transfer an object between views in Django?

Arrange search results using $in array parameter in MongoDB

Looking for assistance in setting a new initial state for a javascript toggle on page load

Choose a paragraph of text that spans multiple lines without exceeding the width