Scheduler From Spreadsheet

# This is a template for a Dockerfile used to run acts in Actor system.
# The base image name below is set during the act build, based on user settings.
# IMPORTANT: The base image must set a correct working directory, such as /usr/src/app or /home/user
FROM apify/actor-node-basic:v0.21.10

# Second, copy just package.json and package-lock.json since it should be
# the only file that affects "npm install" in the next step, to speed up the build
COPY package*.json ./

# Install NPM packages, skip optional and development dependencies to
# keep the image small. Avoid logging too much and print the dependency
# tree for debugging
RUN npm --quiet set progress=false \
 && npm install --only=prod --no-optional \
 && echo "Installed NPM packages:" \
 && (npm list --all || true) \
 && echo "Node.js version:" \
 && node --version \
 && echo "NPM version:" \
 && npm --version

# Copy source code to container
# Do this in the last step, to have fast build if only the source code changed
COPY  . ./

# NOTE: The CMD is already defined by the base image.
# Uncomment this for local node inspector debugging:
# CMD [ "node", "--inspect=0.0.0.0:9229", "main.js" ]

{
    "name": "apify-project",
    "version": "0.0.1",
    "description": "",
    "author": "It's not you it's me",
    "license": "ISC",
    "dependencies": {
        "apify": "0.21.10",
        "moment": "latest",
        "request-promise": "latest"
    },
    "scripts": {
        "start": "node main.js"
    }
}

1const Apify = require('apify');
2const moment = require('moment');
3const requestPromise = require('request-promise');
4
5Apify.main(async () => {
6  // const { sheetId } = await Apify.getValue('INPUT');
7  const sheetId = '1-vpSVo1WjKheduG4YjXoOUfZ6mWaoeSekaiVRVoNV-8';
8
9  if (!sheetId) {
10    throw new Error('Invalid input, must be a JSON object with the "sheetId" field!');
11  }
12  const spreadSheetUrl = `
13    https://spreadsheets.google.com/feeds/list/${sheetId}/od6/public/basic?alt=json
14  `;
15  console.log('Extracting info from:', spreadSheetUrl);
16
17  let json;
18  try {
19    const response = await requestPromise(spreadSheetUrl);
20    json = JSON.parse(response);
21  } catch (err) {
22    throw new Error('Error while getting spread sheet!', err);
23  }
24  const now = moment().startOf('hour');
25  const afterAnHour = now.clone().add(1, 'hour');
26  const defaultTime = moment().startOf('day');
27
28  const { entry } = json.feed;
29  const hashtags = entry.map(({ title, content }) => {
30    const hashtag = title.$t;
31    const [frequency] = [content.$t.match(/\d{1,2}:\d{2}:\d{2} [apm]{2}/i) || defaultTime];
32    const time = moment(frequency, 'HH:mm:ss a');
33    if (time.isBetween(now, afterAnHour)) {
34      console.log('Calling Extractor for', hashtag);
35      Apify.call('juansgaitan/instagram-extract-posts', { hashtag });
36    }
37    return { hashtag, time };
38  });
39  console.log(hashtags);
40  console.log('Done.');
41});