Search results

  1. Lars

    Capture change in any column in a Google Sheet?

    Ok, thanks. I have both enabled but what you're saying is that I should only have Send on event since data is coming from a Google form? The video isn't useful for this case because I can't use the Forms integration since it only handles new submissions, not updates. Instead, I need to capture...
  2. Lars

    Capture change in any column in a Google Sheet?

    I know that formulas etc aren't currently supported as triggers, and I think I've read somewhere that both manual entry and form submissions count as events that will trigger when the Event option is enabled. But now whe I clicked help in the configuation dialogue it said that only manual entry...
  3. Lars

    Capture change in any column in a Google Sheet?

    Slogging along here, learning by trial and error. The latest challenge I've run into now is the New or updated row function for Google Sheets. The sheet I'm tracking is output from Google forms. Since I need to specify a trigger column, I can only track that column, but I need to trigger the...
  4. Lars

    Add or update row in Google Sheets

    I'm fiddling some more with this now, will get back to you if needed. But I don't understand what you're saynig about adding a manula value in the Value column - the whole point here is to check if a preceding lookup step in a Google sheet find the value in the URL filekd, and if not, then...
  5. Lars

    Add or update row in Google Sheets

    Strange - I'm now populating the router and attempting to add new row in sheet, but the selection of columns from the first step doesn't display all the columns. What I'm doing is trigger action when row is added or updated in sheet 1, lookup key value from that row in sheet 2, if key is matched...
  6. Lars

    Add or update row in Google Sheets

    Hej, thanks, I suspected that that would be the answer - and had hoped for a simplified similar to for example Mailerlite integration, where the actions is add/update depending on whether the subscriber exists or not.
  7. Lars

    Add or update row in Google Sheets

    Hi, can't find how to add a step in Connect that will either add a new row if unique key isn't already in an existing row, or update an existing row if key is found. Doable, right? And I'm retrieving the data from another Google sheet (not that it should matter, I suppose). Thanks, Lars.
  8. Lars

    Support for queries and formulas in Google Sheets

    Happy to hear that. Not even a rough idea? This month, first quarter, two years? Right now this is the only reason I'm still paying for Zapier.
  9. Lars

    Support for queries and formulas in Google Sheets

    First a huge thank you to the Pabbly team, I love the work you're doing! That said, I do have a serious complaint and this concerns lacking support for formulas and queries as automation triggers. Zapier has it and I really want to raise your awareness of the importance of this. Aggregating...
  10. Lars

    Trigger Google sheet action from query result

    Also - interestingly - the exact same setup works in a correspond sheet. Hm.
  11. Lars

    Trigger Google sheet action from query result

    Yes, I'm aware of that - and I'm not using ImportRange, just a simple query, although I'm guessing that technically this has the same problems in your implementation. And your answer doesn't help. I need to find a way to solve this that doesn't require manual input, with or without your tools...
  12. Lars

    Trigger Google sheet action from query result

    Hi, I had hoped to be able to trigger a google sheet action using results from a query, but this doesn't work (it does in Zapier ...). To illustrate, here's the query: =query(Underlag!5:99;"select AI, C, BD";0) and the results: Epost Namn Datum andrea*** Andrea 2023-04-24 kontakt***...
  13. Lars

    Repost FB page posts to IG account

    Excellent, thanks, will test!
  14. Lars

    Repost FB page posts to IG account

    Yes, I realize that the format is incorrect, and this is what your FB integration is providing me with, so I'm asking what the right way (if possible) is to create such an automation.
  15. Lars

    Execute step based on value in Google sheet

    I'm looking to automate a follow-up email step in a customer aquisition process. The existing workflow currently ends with a first email to the prospect, and if they haven't signed up after a specific time I want to send a follow-up to them. When they sign up, a column in a Google sheet is...
  16. Lars

    Repost FB page posts to IG account

    I'm trying to automate getting posts on my FB pages to also post on IG. I realize I could use Hootsuite or similar tools and would like to stay FB native while achieving the same effect. I created a workflow using the FB page app and the IG app but I get several immediate errors, see attached...
  17. Lars

    Does every recipient in SMTP app cost one click, or just every execution?

    Ok, thanks - but the Email Parser does the opposite of what I want to do, right? Which is to not only send an email but also store the sent message in the Sent IMAP folder for the account used to send the message.
  18. Lars

    Does every recipient in SMTP app cost one click, or just every execution?

    Hi, just started using the SMTP app. Straightforward enough, and the only thing I'm not clear on is if every execution is always just one click regardless of whether I have one or several recipients in the To field? Also, it would be really useful if there was an IMAP implementation so that...
  19. Lars

    Google search console

    I'd love to be able to automate submissions of new URL's to Google search console. Can't find such an app in Pabbly right now, but perhaps there's a way to solve it anyway? My URL's are stored in a Google sheet and what I'd like to accomplish is every time the URL column gets an uppdated value...
  20. Lars

    Unclear about pricing

    At https://www.pabbly.com/connect/#pricing it looks like the only difference between the plans is the number of tasks per month, whereas the life-time offer also has feature limitations between the levels, see...
Top