Recent

Author Topic: IFTTT & Google Sheets Issue  (Read 2545 times)

0 Members and 1 Guest are viewing this topic.

Offline SkillSans

  • New Member
  • *
  • Posts: 3
IFTTT & Google Sheets Issue
« on: February 13, 2020, 07:23:33 AM »
Hi, has anyone got experience of using IFTTT in conjunction with Google Sheets?

I have got so far in a small project but am now hitting a snag.

Every time I run an applet that is intended to add a track to a Spotify playlist, it gives an error (saying "THERE WAS A PROBLEM WITH GOOGLE SHEETS" followed by "No Details Available").

I don't trust this error message, as the first step also utilises Google Sheets, and runs without any errors - so I think it something I am not doing correctly. (I have also ran a simple test in a different folder, using Google Sheets which also works fine)

(I should have pointed out - I have extremely limited experience with spreadsheets in general)



Still with me? I'll try and explain what I think may be going wrong....


The final stage in the process is to do a search on Spotify of a Track (columnB) and the Artist (columnA). The spreadsheet that these search terms are inputted into has "VALUE!" In the cells that haven't been occupied yet. Does this mean that when IFTTT tries to do a search, it will be attempting to do a search from the last row (ie "VALUE!") rather than the new Track/Artist that is further up the spreadsheet?


Hope this makes enough sense for someone to assist!
(I can make screenshots later tonight if that gives any better info to anybody)

Offline Tracy

  • Ninja Master
  • **
  • Posts: 7910
  • Gender: Female
Re: IFTTT & Google Sheets Issue
« Reply #1 on: February 13, 2020, 11:12:20 AM »
In excel spreadsheets, VALUE means there is something wrong
you may want to do a search to fix this in the program you are using.

Not sure any one here is using google sheets
Good luck!

Offline born2print

  • Post count: purtygood
  • Supreme Ninja
  • ***
  • Posts: 12328
  • Gender: Male
Re: IFTTT & Google Sheets Issue
« Reply #2 on: February 13, 2020, 01:54:25 PM »
yeh, I just use them for personal stuff, good to share a list with someone, etc...
Good luck though
Quote from: Tracy link=msg=301939 date=1534265274
I get back to my dept and I'm all bleep you and bleep this bleep :laugh:

Offline pspdfppdfxhd

  • Ninja Member
  • *
  • Posts: 2751
  • Gender: Male
Re: IFTTT & Google Sheets Issue
« Reply #3 on: February 14, 2020, 07:17:39 AM »
Google sheets? WTF is that? Oh no...... first there was Canva and now there is google sheets....

 :facepalm: :drunk3:

Offline DPSprint

  • Hero Member
  • *****
  • Posts: 525
Re: IFTTT & Google Sheets Issue
« Reply #4 on: February 16, 2020, 01:27:48 PM »
Google sheets? WTF is that? Oh no...... first there was Canva and now there is google sheets....

 :facepalm: :drunk3:
LOL I have actually had artwork created from google sheets.... school magazine  :hangme:
its so much fun